Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |