Create a table of part numbers and descriptions in say M1:N10 and use

=VLOOKUP(B9,$M$1:$N$10,2,False)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Terranoman" wrote in message
...
I am trying to set up a formula so that when I input a specific alpha
numeric
product number in b9 a text description is automatically input by excel
into
c9 for that item. I can get it to work with one part number and
description
but is it possible to have multiple choices for the same cell range? I
have
tried but I get the #Value code.

An example of the current formula I have been using in C9 is:

=if(b9="ABC123Q","Nissan Terrano II Gear Box")

Can anyone advise me if I can add to this e.g.

=if(b9="ABC123Q","Nissan Terrano II Gear Box")or(if(b9="QZF99t","Fiat
Thrust
Bearing")

Or is there an alternative to the OR function? There will usually be 1 of
5
possible codes input in each cell.