Formula needed

Hi,

 

I am trying to establish a formula to reference certain cells between two tables as the below.

 

Sheet1

 

Sheet2

 

In Sheet1

Return the type of meal in column C by matching the name and fruit type from Sheet1 to Sheet2. Values should return as follow. Please note, the data I am working on is more than 2 rows and therefore I need a formula that would be valid when applied to multiple rows not just 2.

Thank you!

By: Alaya

Leave a Reply

Your email address will not be published. Required fields are marked *