VLOOKUP problem

  • Thread starter Thread starter ikhsan nugraha
  • Start date Start date
I

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
 
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
 
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.
 
Back
Top