Excel - LOOKUP Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.