VLOOKUP

Posted by Andonny on December 18, 2000 2:26 PM

Hi,
I was wondering why I can't get an exact match of A in F2. All the others are an exact match in column F. The vlookup formulas of column F are below. If this is normal how do I reproduce an exact match.

A B C D E F
1 Alean F Alean Alean F
2 Leonard D Leonard Leonard A
3 Joel A Joel Joel A
4 Philip B Philip Philip B
5 Stanley A Stanley Stanley A

F
=VLOOKUP(E2,B$2:C$7,2,1)
=VLOOKUP(E3,B$2:C$7,2,1)
=VLOOKUP(E4,B$2:C$7,2,1)
=VLOOKUP(E5,B$2:C$7,2,1)
=VLOOKUP(E6,B$2:C$7,2,1)

Thanks a lot for your help
Andonny

Posted by Andonny on December 18, 2000 2:36 PM

Sorry it got a bit messy.
I placed a sample on my webpage:
http://www.multiline.com.au/~wje/vlookup.html

Posted by Bruce on December 18, 2000 2:47 PM

Try looking for an exact match by using this formula
=VLOOKUP(E3,$B$2:$C$6,2,FALSE)

Posted by Bruce on December 18, 2000 3:21 PM

I used =VLOOKUP(E3,$B$2:$C$6,2,FALSE)
you could also use =VLOOKUP(E3,$B$2:$C$6,2,0)