**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.*