Hi,

If I understand, you want to lookup say in column H and bring back the
result in column G. If so you can't use VLOOKUP, instead use

=INDEX(G1:G100,MATCH(A1,H1:H100,0))
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kenbquik" wrote:

I have a lookup formula that looks up data in the last column. The last
column contains zeros so the formula returns a non zero number from the
column before. How do I fix to have the lookup bring the numbers in the
column including zero.