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

Word VBA - Automatic change content of a cell in table using dropdown list 5
Dropdown list with 2 columns 3
hyperlink from dropdown list 6
Word macro that can call cells out of Excel for a find and replace 0
Excel Formula's 5
Counting or summing up a group of cells with dates as datas 3
Vlookup using a dropdwn list, check different tables based on drop 2
Dropdown selection changes the colour of the cell or deletes a row 6

Top