Can a Dropdown list change neighoring cells base of what is select

M

Mattb

I have created a dropdown list in Column A. Dropdown list is made up of
finsihes (1st, 2nd, 3rd, 4th, etc.) Each finish is worth a different point
value. 1st =800, 2nd = 750, etc. What I would like to happen is have the
adjacent B Column reflect the value based on what place is selected. Is this
possible?
 
S

Sean Timmons

couple of options here.

You can create a table with place # in column A and point value in column B...

Then, you put in a formula such as:

=VLOOKUP(F2,A2:B20,2,false)

Where F2 is your drop-down value and A2:B20 is your table with place # and
value
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dropdown list with 2 columns 3
hyperlink from dropdown list 6
How can I create a drop down list from non-adjacent cells 4
Counting or summing up a group of cells with dates as datas 3
Excel Formula's 6
Vlookup using a dropdwn list, check different tables based on drop 2
Unhiding rows as a result of selection in dropdown list 7
Creating a dropdown list based on selection from a differernt drop 5

Top