Drop down list problem
Hey all,
I have a peculiar problem.
Currently i have a table for reference,
Food Price
AAA $1
BBB $2
CCC $3
I have created a drop down list using Data Validation.
However, i require the drop down to display selection of food, but display the prices upon selection
Is that possible in Excel?
Thanks all!
Last edited by septeal; 03-11-2013 at 09:59 AM.
Create a table with all foods and their prices and then in columnB, use INDEX & MATCH to get the prices.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
however, for the cell in interest here, the cell is restricted by data validation already due to the dropdown list, how do i input the index and match code into that cell?Originally Posted by Fotis1991
What i mean is.: In Column A(for example) you'll have your validation list and in Column B your INDEX & MATCH.
ah i see. sorry about that.
i need it to be the same cell, where the dropdown list is. Is it possible to achieve this in Excel?
i can't think of ways other than using at least 2 cells.
Hi septeal
Do you mean a dependent list!
Data Validation
Regards Kevin
Merged Cells (They are the work of the devil!!!)
Hi septeal..
I don't think that's possible because of circular reference....
Jason...
You need to work on atleast 2 cells...
hmmm yea i was wondering the same
right now i have two cells two, one with data validation, the other with vlookup
but i kinda need it to be on just 1 cell. Example, choosing AAA in the dropdown list, produces the value $1 upon clicking.
Not possible septeal... Circular reference!!!!!!!!!
yup, thanks alot for the advice guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks