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)
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
Submit an answer
