Hi all,
We are working on a meal planning application in excel, but are facing a problem. Our main goal is to select an ingredient and unit so that it returns the right number of calories. However, due to duplicate values in the row with units, it returns the wrong number of calories.
The ingredient can be chosen in G3, which uses data from row E, which itself uses data from row A (minus duplicates). No problems are seen here.
The unit can be chosen in H3, which doesn’t cause any problems as well.
The next step is problematic for us. Because of duplicate units (for example ‘100 gram’), we only get the corresponding calories of the top selection. I’ve tried solving the problem with VLOOKUP and OFFSET/MATCH functions but can’t seem to figure it out.
Hopefully someone can help us out. Much thanks in advance!
Renzo
P.S. The data in this file is fictional, as we've created it as example
Bookmarks