LinkBack URL
About LinkBacks
How can I make an Excel field that will automatically fill in a numerical value in Column B based on a selection from a drop-down list in Column A?
How can I make an Excel field that will automatically fill in a numerical value in Column B based on a selection from a drop-down list in Column A?
Depends on what the relationship is between the number and the input value...
Do you have a lookup table somewhere?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi bigchalk,
welcome to the forum.
You will need to set up a table somewhere in your workbook, where you list the possible selection values for your drop down and in the next column list the numbers that belong to these values.
Then use Vlookup in column B to find the match for the value selected in column A
=Vlookup(A1,$X$1:$Y$10,2,false)
In this example, the lookup table is in columns X and Y.
Does that help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks