smokemalls
New Member
- Joined
- Sep 14, 2005
- Messages
- 22
=VLOOKUP(A:A,$A$1:$B$4,2)
The above looks up value in column A in range A1:B2 and returns value in column 2. Is it possible to look up value in collumn B in range A1:B4 and return value in column 1 eg;
=VLOOKUP(B:B,$A$1:$B$4,1)
This does not work though. Is there a way around this please???
Cheers
The above looks up value in column A in range A1:B2 and returns value in column 2. Is it possible to look up value in collumn B in range A1:B4 and return value in column 1 eg;
=VLOOKUP(B:B,$A$1:$B$4,1)
This does not work though. Is there a way around this please???
Cheers