help with lookup please
 

hi guys, im sure this is a easy one
im using a lookup function. what i want to do is use and a cross
reference.
1a a 2 b
2 b
3a c
4 d
5a e
above is what im talking about. formular is =LOOKUP(D1,A1:A5,B1:B5)
and that works fine except if the figure i put in D1 isnt exactly the
same as in in A1:A5 ie type 3 instead of 3a the result will be the
previous line (b)
is there a way of doing a exact lookup or some way to return a false or
error if it cant find an exact result.

i hope that makes sence

Scott


--
westie13
------------------------------------------------------------------------
westie13's Profile: http://www.excelforum.com/member.php...o&userid=35490
View this thread: http://www.excelforum.com/showthread...hreadid=552635

help with lookup please
 

.. =LOOKUP(D1,A1:A5,B1:B5)

Try VLOOKUP with the 4th param set to zero (or FALSE) for an exact match:
=IF(D1="","",VLOOKUP(D1,{"1a","a";2,"b";"3a","c";4 ,"d";"5a","e"},2,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"westie13" wrote:

hi guys, im sure this is a easy one
im using a lookup function. what i want to do is use and a cross
reference.
1a a 2 b
2 b
3a c
4 d
5a e
above is what im talking about. formular is =LOOKUP(D1,A1:A5,B1:B5)
and that works fine except if the figure i put in D1 isnt exactly the
same as in in A1:A5 ie type 3 instead of 3a the result will be the
previous line (b)
is there a way of doing a exact lookup or some way to return a false or
error if it cant find an exact result.

i hope that makes sence

Scott


--
westie13
------------------------------------------------------------------------
westie13's Profile: http://www.excelforum.com/member.php...o&userid=35490
View this thread: http://www.excelforum.com/showthread...hreadid=552635