Chosen Text in dropdown adds number in cell

[Closed]
Report
-
Posts
2
Registration date
Wednesday March 12, 2014
Status
Member
Last seen
March 12, 2014
-
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

Posts
2
Registration date
Wednesday March 12, 2014
Status
Member
Last seen
March 12, 2014

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!