Hi Rocco, a very warm welcome to the forum!
I went through your work file. Are you trying to get the details based on the selected food item? Details like unit, fat, carbs, proteins, leucine and stuffs? If this is what you're looking for, then VLOOKUP should be your first choice. This function actually performs a vertical lookup to which you pass 4 parameters that helps you locate what you're looking for..
1. Lookup_Value - is the string that you're searching among a list of table containing the data.
2. Table_Array - is the reference table from which you'll searching the string first and then corresponding details to that row if found.
3. col_index_number - is the column which will contain the result which you desire to retrieve.
4. range_lookup - is a boolean parameter that instructs the function about the type of search you're performing. An approximate or exact match..
Please find your attached re-worked file of yours that shows the same application. Hope, this is what you're looking for.
Bookmarks