P
PeterG
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.
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.