I have a table in which

ID  Product Name
1   Alto
2   Aveo
3   Aveo UVA
4   A star
5   Eeco
6   800
7   Omni
8   Zen
9   Zen Estilo
10  Versa

.... and so on of database of over 300 products

Now i have created a new sheet in the said spreadsheet Have a created a drop down list to select from Product Name However want ID to be automatically filled and in a separate column based on Product Name selected.

can any one help Vlookup function or what else, not able to create how to create matching id from the product name enter image description here

enter image description here

Excel Sheet Data


You can use Index:


Table-Code!$B$2:$B$300 is your initial Table-Code Id column change it to correspond your data

Table-Code!$B$2:$B$300 is your initial Table-Code Product column change it to correspond your data
B2 is where you have the drop down box Product Name, Model in Stock-List
In C2 write the formula
Iferror in case of no match or empty cell

| improve this answer | |
  • thanks, i have modified question with attached pic of data. Can you help basis same – Ruchika Aug 29 '17 at 3:19
  • I modified the formula to correspond your Tables – yass Aug 31 '17 at 18:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.