VLOOKUP problem

[ikhsan nugraha]

All,

I tried to used the vlookup function. The lookup value is
from the list. It was ok for the first lookup. But for the
second line, the value given was wrong, it gave me the
highest number in the lookup table. The file is attached.
Could anybody help me to solve this problem?

Thanks and Regards,

Ikhsan Nugraha
Indonesia

 

[John]

Hi,

can't see the attachment but...
have you fixed the reference cells in the vlookup formula,
using the $ symbol?
=vlookup(A1,$B$1.$C$100,2,0)

if these weren't fixed and you copied the vlookup formula
to other cells it wouldn't work for you.
Anternatively name the range.

HTH,
John

 

[Kerry \(ExcelAid\)]

Hi Ikhsan

If you send your file to (e-mail address removed), i'll
be happy to fix this problem for you.

regards,
Kerry
www.excelaid.com

 

[Dave Peterson]

First, your attachment didn't come through--and that's a good thing. Most
people won't open attachments and some get darn right annoyed when they see
them.

But I'm guessing your =vlookup() formula was missing the 4th parm:

=vlookup(a1,sheet2!$a$1:$b$999,2,false)

That False tells excel to look for an exact match (a1 to somewhere in Sheet2,
A1:A999).

If that's not the problem, you should post the formula--just copy it to your
message--no need to attach a workbook.