i dont use excel that mush what i am trying to do lookup a colum a1:a:20 in another sheet2 b2:b:20 and bring up the result of sheet2 colum c2:c20.
which is not a problem but in my list i am looking up i have more then whats in sheet2 and i want it to return 0.

lookup

a
b
c
d
e

sheet2

a 20
b 22
d 34
e 36

i keep getting my result as

a 20
b 22
c 22
d 34
e 36

Howdy. What formula are you using? Can you provide exactly what it is? It probably is either a wrong last element or a missing last element.

Look at the VLOOKUP() function in the Help. It's your ticket.

Sam