multiable formulas for one cell - "IF"

[stilgar]

I've created an sheet with drop-down menus of product descriptions for our company and i want another cell to put the part number in another cell depending on what is selected.

there are 2 to 3 values needed sometimes to determine the correct part number.

eg: if cell "a1" = value "A" and cell "a2" = value "B" then cell "b1" will enter part number "X"

or

if cell "a1" = value "C" and cell "a2" = value "B" then cell "b1" will enter part number(autofill) with value "Y"

The values are product descriptions selected from the dropdown menus.

all the part numbers on on sheet 2 and the form is on sheet 1. also on sheet 2 are product descriptions and other options for the dropdown menu's

Any help would be great.

 

[MrKowz]

Try:

=IF(AND(A1="A",A2="B"),"X",IF(AND(A1="C",A2="B"),"Y",""))

 

[sach.gaikwad]

How to write 2'-6" i.e 2 Feet & 6 Inch in excell

 

[stilgar]

works a treat mate! thankx heaps!

 

[sach.gaikwad]

How to write 2'-6" i.e 2 Feet & 6 Inch in excell