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