Setting a Variable to have multpile values

[arsenal6106]

Hi,

I'm trying to create a simple nutrition log on excel.

For example, I want excel to display 5 in B1, 3 in C1, and 6 in D1 when i type in Bread in A1.


How would i go about doing this?

Plz help

Thanks in advance

[Paul]

Hi Arsenal, and welcome to the forum.

Do you have a table of data somewhere in the workbook that tells you that the three values associated with Bread are 5, 3 and 6?

If so, you may want to try VLOOKUP. I've attached an example for you to review. For specifics on the four arguments of VLOOKUP, check the Excel Help files.

[arsenal6106]

Thanks for the response. I used the help function on excel to find out more info on vlookup. But im still confused in what i need to select when it comes to look up value, table array, col index num, and range look up. I think you select ur data for table array, but everything else is still confusing to me. In addition, which cell needs to be highligthed when selecting vlookup.

Further help will be appreciated with the example you attached

Thank You!

[arsenal6106]

Actually, I just figured it out!

Your example was exactly what i needed.

Thank you for the help!