If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
LookUP function with multiple variables and worksheets
I am trying to create a formula for the following:
If Col A on worksheet 1 = Col B on worksheet 2 AND Col B on worksheet 1= Col C on worksheet 2 then the value of cell X equals the value of cell Y. I need 2 sets of data to match exactly in order to use the value found in a third location. Is this possible to do or do I need to break down into multiple steps? Thanks |
#2
|
|||
|
|||
LookUP function with multiple variables and worksheets
Try this in cell_X:
=IF(AND(Sheet1!A1=Sheet2!B1,Sheet1!B1=Sheet2! C1),cell_Y,something_else) You decide what you want the something_else to be (eg "" or 0). Hope this helps. Pete On Mar 18, 4:55*pm, mjwk wrote: I am trying to create a formula for the following: If Col A on worksheet 1 = Col B on worksheet 2 AND Col B on worksheet 1= Col C on worksheet 2 then the value of cell X equals the value of cell Y. * I need 2 sets of data to match exactly in order to use the value found in a third location. Is this possible to do or do I need to break down into multiple steps? Thanks |
Thread Tools | |
Display Modes | |
|
|