The syntax is: =VLOOKUP(C8,AZ1:BB1578,3)

Another possible cause of "strange" errors could be due to the table_array
not being fixed (i.e. "AZ1:BB1578" instead of "$AZ$1:$BB$1578") as the
formula is copied down from the starting cell

If the above formula is used in the starting cell, say in D8, which is then
copied down, take the precaution to put in D8 as:
=VLOOKUP(C8,$AZ$1:$BB$1578,3)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--