Forum Discussion
VLOOKUP HELP NEEDED
after having an upgrade to 365 I am now unable to complete reports as the old formula see below now gives me an error message #NA how can I get over this problem ? HELP =VLOOKUP(F5,COMMUNICARE!$1:...
does it work if you add a column reference to your array?
=VLOOKUP(F5,COMMUNICARE!$A1:$ZZ1048576,1,FALSE)