in reply to Unable to compare 2 arrays from 2 separate columns of separate sheets.
You seem to be using a spreadsheet module. Which one is it? Please, try to provide a SSCCE so we can run your code and experiment with the fixes.
map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]
In Section
Seekers of Perl Wisdom