VLookUp

[Louise]

Hi all

I have created a worksheet which contains a VLookUp table
and it works fine, however, I have another worksheet with
similar information on and have, therefore, created an
identical LookUp table. For some reason, I cannot get the
formulas to work and they all return zero. My LookUp
table looks like:-

A B

0 S
50000 M
100000 L
300000 XL
500000 2XL

E3 contains a figure of 69000 and I am trying to create
the LookUp value in D3, using the LookUp table above,
however, it always returns the answer as 0.

Does anybody know what I'm doing wrong? I can't
understand it as when I used this table on another
workbook, it worked fine.

Please help.

Thank you.

Louise

 

[Frank Kabel]

Hi
post your formula

 

[Govind]

Hi,

Try

=VLOOKUP(E3,A1:B100,2,TRUE)

Regards

Govind.

 

[Louise]

My formula reads:-

=VLOOKUP(E3,table,2)

I can't understand why it doesn't work because I have
used the identical formula and LookUP table on several
other workbooks and they are fine.

Thanks.

Louise

 

[Louise]

I've managed to work out what was wrong. A formula in
another column was incorrect and this, therefore, had a
knock-on effect on the VLookUp.

Thanks any way.

Louise

 

[Frank Kabel]

Hi
to look for an exact match use:
=VLOOKUP(E3,table,2,FALSE)

 

[Frank Kabel]

Hi
disregard this post. I misread your original table as
you're not looking for an exact match.