Hi all,

I have a Lookup formula setup to validate what the user enters against
a list of stock codes, returning the item costs. Stock codes are
A001, A002 etc, B001, B002, etc, D001, D002 etc If I then enter a
stockcode starting with letter C, I get the item cost returned from the
last letter B stockcode. How can I get it to return P.O.A.

This is what I have at present.

=IF(C4="Fittings",(LOOKUP(F4,Fittings!$C$1:$C$5019 ,Fittings!$D$1:$D$5019)),0)*AL4

C4 - Parent stock item description
F4 - Stock code
AL4 - Quantity

Any help - greatly appreciated.


--
PeterG
------------------------------------------------------------------------
PeterG's Profile: http://www.excelforum.com/member.php...o&userid=16485
View this thread: http://www.excelforum.com/showthread...hreadid=386727