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.