Forum Discussion

Deleted's avatar
Deleted
Aug 24, 2018

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)

 

Formulas and Functions
office 365
  • Philip West's avatar
    Philip West
    Steel Contributor
    Aug 24, 2018

    does it work if you add a column reference to your array?

     

    =VLOOKUP(F5,COMMUNICARE!$A1:$ZZ1048576,1,FALSE)

Resources