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

**godlev** · 12-21-2011, 06:01 AM

Hi all,

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

Please Login or Register  to view this content.

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

**zbor** · 12-21-2011, 06:10 AM

Change your formula to match your data:

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

**godlev** · 12-21-2011, 06:27 AM

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!