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
GeoffRies Posts 2 Registration date Wednesday March 12, 2014 Status Member Last seen March 12, 2014 - Mar 12, 2014 at 09:35 AM
Related:
- Chosen Text in dropdown adds number in cell
- Pdf and xps add in 2007 - Download - Other
- How to add @ in laptop - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- How to add watermark in word - Guide
- How to add photo in word resume - Guide
1 response
GeoffRies
Posts
2
Registration date
Wednesday March 12, 2014
Status
Member
Last seen
March 12, 2014
Mar 12, 2014 at 09:35 AM
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!
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!
