Last answered:

16 Feb 2023

Posted on:

16 Feb 2023


value not available error

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.

1 answers ( 0 marked as helpful)
Posted on:

16 Feb 2023


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.



Submit an answer