I am trying to do a VLOOKUP or equivalent to search the attached data table and display the cost of the Grapes/White/Bitter which cost 4
I am having trouble because there is multiple criteria that is the same. First there are multiples of the same fruit then there are multiples of the same type. The taste is the criteria that separates them and I need to display the cost in a new cell.
Please help!
Bookmarks