Chosen Text in dropdown adds number in cell
Closed
dexxnl
-
12 Mar 2014 à 05:47
GeoffRies Posts 1 Registration date Wednesday 12 March 2014 Status Member Last seen 12 March 2014 - 12 Mar 2014 à 09:35
GeoffRies Posts 1 Registration date Wednesday 12 March 2014 Status Member Last seen 12 March 2014 - 12 Mar 2014 à 09:35
Related:
- Chosen Text in dropdown adds number in cell
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add at the rate in laptop - Guide
- How to add signature in thunderbird with image and text - Guide
- How to delete cell in word - Guide
- How to add a checkmark in word - Guide
1 response
GeoffRies
Posts
1
Registration date
Wednesday 12 March 2014
Status
Member
Last seen
12 March 2014
12 Mar 2014 à 09:35
12 Mar 2014 à 09:35
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!
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!
