Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,Sheet1!B5=Sheet2!B5),Sheet3!A1,"NO MATCH")

HTH,
Barb Reinhardt
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use & with two formulas 2
Combining an IF with another formula 4
Searching the formula (not the value) for a text string 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Formula to choose from the last column of a given row 1
Auto filling a table of numbers 3
If function 3
Dependent drop down dynamic range formula, off sheet. 7

Back
Top