Chosen Text in dropdown adds number in cell

Closed
dexxnl - Mar 12, 2014 at 05:47 AM
GeoffRies Posts 2 Registration date Wednesday March 12, 2014 Status Member Last seen March 12, 2014 - Mar 12, 2014 at 09:35 AM
Hello,

I have a problem with my formula,

If i choose a product "text" in a dropdown menu in cell C2, i want it to display a serial number in Cell C4.

The product and serial numbers are located on a second page. cell C2 and D2

=IF ( C2=" text ", C4..... ?

Thank you a lot for helping.



1 reply

GeoffRies Posts 2 Registration date Wednesday March 12, 2014 Status Member Last seen March 12, 2014
Mar 12, 2014 at 09:35 AM
Hi,

You don't need an IF statement for this. Just use a lookup formula.

I assume that your product and serial numbers are listed in two columns, rather than rows. So use the vlookup (vertical lookup). If they're in rows, then used the hlookup (horizontal lookup).

The formula you need is:

=vlookup(C2,*table array*,*column index number*,false)

*table array* - This is the table that your product and serial numbers are in. You need to ensure that your product list is on the left hand column. Highlight this table while writing this formula

*column index number* - This is what number column the information you want returned in. So if you have only two columns "Product" and "Serial number" then you would put 2 in this part of the formula

false - will ensure only an exact match is returned


Hope this helps!
0