Forum Discussion
Help with Vlookup
I have created a table with food items in a drop down list and I want to be able to select something from the list so that when entered it also puts in the calorie count of that item in an adjacent cell. I have one table with columns Breakfast, Lunch and Dinner all have dropdowns with the list of foods The adjacent column is for the calories. I have another sheet which holds the list of foods with the calorie count in the adjacent cell. Any ideas - please bear in mind I am very green with excel
I'm not sure if I understood him correctly, but here's what I understand🙂.
My answer is without guarantee.
Hope this helps you.
2 Replies
I'm not sure if I understood him correctly, but here's what I understand🙂.
My answer is without guarantee.
Hope this helps you.
Brilliant thankyou so much. Now another issue is how can I hide the N/A in cells with nothing in. Ideally without losing formulas so eg. If food item is clear then clear calorie cell
