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:$1048576,1,FALSE)
does it work if you add a column reference to your array?
=VLOOKUP(F5,COMMUNICARE!$A1:$ZZ1048576,1,FALSE)
