Forum Discussion

Copper Contributor

Mar 23, 2022

Solved

Give a number value to text in a drop down list.

I'm trying to create a cutting forces calculator, I want to be able to select what material is being used from a drop down list. The problem is the formula needs it to be a number value. On my second...

excel

Formulas and Functions

Macros and VBA

HansVogelaar
Mar 23, 2022
Jaxsondville

You can use the VLOOKUP function for this:

=VLOOKUP(B4, 'Material List!A:B, 2, FALSE)

HansVogelaar

MVP

Mar 23, 2022

Jaxsondville

You can use the VLOOKUP function for this:

=VLOOKUP(B4, 'Material List!A:B, 2, FALSE)

Jaxsondville

Copper Contributor

Mar 23, 2022

Thank you, I originally was wanting it to just be one cell that had the list and somehow spat out number values as well, but I shifted the list cell to the right one column and used B4 for the VLOOKUP. This ended up making it so the number shows up in the cell, but the name is still displayed to the right.