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