Question description:
This user has given permission to use the problem statement for this
blog.
I would like to use some sort of lookup to generate data based on a dropdown list value.
Solved by T. W. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
09/08/2018 - 04:39
?
Excelchat Expert
09/08/2018 - 04:39
Hi
Excelchat Expert
09/08/2018 - 04:40
Welcome to Got it Pro
Excelchat Expert
09/08/2018 - 04:40
Please tell more about the requirement so that i can help you better
User
09/08/2018 - 04:41
I would like to use Excel to generate meal plans. I have one sheet with lists of meals, including calorie and nutrient count. On the second sheet, I have a dropdown list for each meal type that will let me select one of the options.
User
09/08/2018 - 04:41
For example, in the "BREAKFAST" option I have a dropdown containing "EGGS," "OATMEAL," "CEREAL."
Excelchat Expert
09/08/2018 - 04:42
Can you share the data on the spredsheet
User
09/08/2018 - 04:42
I would like, for example, if I pick "EGGS," the next cell will autopopulate with the calorie count for EGGS
User
09/08/2018 - 04:42
I don't have the sheet on this computer, unfortunately.
User
09/08/2018 - 04:43
So if, in B2, I pick "EGGS," cell C2 should autopopulate with "70."
User
09/08/2018 - 04:44
I'd like to do it this way because I don't have an app that can do this all for me.
Excelchat Expert
09/08/2018 - 04:44
Now change and see the values in column C
Excelchat Expert
09/08/2018 - 04:44
Cell C2
Excelchat Expert
09/08/2018 - 04:45
In column H and I i have taken sample values
User
09/08/2018 - 04:45
That's exactly correct!
Excelchat Expert
09/08/2018 - 04:45
Let me know if that helps
Excelchat Expert
09/08/2018 - 04:45
You can just use the vlookup to get those values
User
09/08/2018 - 04:45
I was looking at other forums and found a bunch of people telling me there were issues using lookups with a dropdown list.
Excelchat Expert
09/08/2018 - 04:45
Not really
Excelchat Expert
09/08/2018 - 04:45
You just saw it is working fine
Excelchat Expert
09/08/2018 - 04:45
Please do give good rating and reviews
Excelchat Expert
09/08/2018 - 04:45
It really helps a lot
User
09/08/2018 - 04:45
How does it work, though?
Excelchat Expert
09/08/2018 - 04:46
=VLOOKUP(B2,$H$2:$I$4,2,0)
Excelchat Expert
09/08/2018 - 04:46
This is the formula
Excelchat Expert
09/08/2018 - 04:46
It matches the value in B2 to values in column H and print values in front of them
User
09/08/2018 - 04:46
And there's no problem getting it to work based on the result of a dropdown?
Excelchat Expert
09/08/2018 - 04:46
That is how vlookup function is designed to work
Excelchat Expert
09/08/2018 - 04:46
No
Excelchat Expert
09/08/2018 - 04:46
It should work fine in all the cases
User
09/08/2018 - 04:46
Well, hell. If I'd known that I would've tried that to start. I use lookups all the time for class projects.
Excelchat Expert
09/08/2018 - 04:47
I guess it is solved now
Excelchat Expert
09/08/2018 - 04:47
Hoping to get good rating and reviews from you
User
09/08/2018 - 04:47
That was stupidly easy. Thank you.
Excelchat Expert
09/08/2018 - 04:47
Have a great day
Excelchat Expert
09/08/2018 - 04:47
Take Care
User
09/08/2018 - 04:47
You too.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
