help with lookup please

[westie13]

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

[Max]

> .. =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
>
>