Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Question with multiple dynamic variables | Excel Worksheet Functions | |||
Lookup function using 2 variables | Excel Worksheet Functions | |||
lookup function for multiple worksheets...and then 'some' | Excel Worksheet Functions | |||
showing lookup result with multiple variables | Excel Discussion (Misc queries) | |||
Lookup (multiple variables) | Excel Worksheet Functions |