I'm trying to finish the 2018 part and keep getting "value not available error" with a green flag. I had no problen with the other two. I'm using this formula, =VLOOKUP($B95,'1.3 FY2018'!$C$5:$E$78,2,FALSE) any suggestions? Yes I use commas, that is correct.

Hi Donald, Please make sure that the lookup value corresponds to at least one value in the table. Keep in mind that It needs to be written in the exact same way in both places. Sometimes blank spaces or typos are the reason for issues as the one you're experiencing. Best, Ned

Follow this topic

Donald Trenholm

Last answered:

16 Feb 2023

Posted on:

16 Feb 2023

value not available error

in Introduction to Excel / Using Lookup Functions (Vlookup) to Fill the Database Sheet

1 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

16 Feb 2023

value not available error

Submit an answer

related questions