Thread: IFERROR and VLOOKUP returns N/A can you help me fix it

Hi all,

i have used the following formula in order to calculate the paid leave for employee

=IFERROR(VLOOKUP(A3,Dec!$A$1:$AS$10,8,FALSE),0)

now i created new schedule for 2012 and the formula returns always N/A

please see attached file and help me fix it.

i just want to search the name of the employee and then return the value from column 8

Change your formula to match your data:

=IFERROR(VLOOKUP(A3,Dec!$E$5:$AS$10,4,FALSE),0)

zbor thank you !!!

this fixed my issue, now i got the syntax, so the column number starts from the column where it is searched the names.

i confirm that you are forum guru!