ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula (https://www.excelbanter.com/excel-worksheet-functions/93488-formula.html)

I got two tabs each with an table. Now I want to use an formula which does
the following thing: It should check if the first three cells from the first
table are the same as in the second table, if they are the same then it
should give the outcome from another cell. Could somebody help me?

I'll do the best I can given the limited information given.

Let's say you want to compare
Sheet1!B3 to Sheet2!B3
Sheet1!B4 to Sheet2!B4
Sheet1!B5 to Sheet2!B5

and if they all match, you want the value from Sheet3!A1

=IF(AND(Sheet1!B3=Sheet2!B3,Sheet1!B4=Sheet2!B4,Sh eet1!B5=Sheet2!B5),Sheet3!A1,"NO MATCH")

HTH,
Barb Reinhardt

"Jor" wrote:

I got two tabs each with an table. Now I want to use an formula which does
the following thing: It should check if the first three cells from the first
table are the same as in the second table, if they are the same then it
should give the outcome from another cell. Could somebody help me?