Forum Discussion

Anonymous's avatar
Anonymous
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

1 Reply

  • Philip West's avatar
    Philip West
    Iron Contributor
    Aug 24, 2018

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

     

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

Resources