Dropdown Lists and alternative cell references

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a two column sheet which has a descriptor cell and then a cell with a
value for that descriptor. Looking at the example below, does anyone know
how, if I have a dropdown list for "Column A" and someone chooses "Rice", can
I reference "$3" somehow?
Column A Column B
Rice $3
Beans $4
Corn $2
 
Let's say your data start from A5:B500, and your drop down in A2

in B2 =VLOOKUP(A2,A5:B500,2,0)
 

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

Sorting day names chronologically 5
Copy corresponding cell in Column B if cell in A contains certain text? 1
Looking up a value in a list & returning multiple corresponding va 1
Help With MS Access 4
Dependent dropdowns 4
Dropdown list with named cells 1
Validation Drop Down List if cell meets criteria 3
dropdown list within IF statement? 1

Back
Top