Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Need to lookup referencing 2 variables
Here is what I am attempting: On worksheet 2, I want to reference worksheet
one looking at 2 variables. What I want is to reference column D if columns I and K meet my criteria. Column I has salespeople, so text is repeated throughout. Column J is dates. Column B is products. I want to find a formula that will keep up with changes in data. Please help!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Need to lookup referencing 2 variables
Guessing from these lines ..:
On worksheet 2, I want to reference worksheet one looking at 2 variables. What I want is to reference column D if columns I and K meet my criteria. In Sheet2, Assuming you have the dual criteria values for col I and K listed in A2:B2 down In C2, array-enter (press CTRL+SHIFT+ENTER): =INDEX(Sheet1!D$2:D$100,MATCH(1,(Sheet1!I$2:I$100= A2)*(Sheet1!K$2:K$100=B2),0)) then copy C2 down as far as required. Adapt the ranges to suit the max expected extents of data in Sheet1. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Need to lookup referencing 2 variables
I am only getting one result, and it is repeating in the copied cells. I can
llok and see that there is more than 1 result, but they are not coming up. "Max" wrote: Guessing from these lines ..: On worksheet 2, I want to reference worksheet one looking at 2 variables. What I want is to reference column D if columns I and K meet my criteria. In Sheet2, Assuming you have the dual criteria values for col I and K listed in A2:B2 down In C2, array-enter (press CTRL+SHIFT+ENTER): =INDEX(Sheet1!D$2:D$100,MATCH(1,(Sheet1!I$2:I$100= A2)*(Sheet1!K$2:K$100=B2),0)) then copy C2 down as far as required. Adapt the ranges to suit the max expected extents of data in Sheet1. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Need to lookup referencing 2 variables
Ah, you've now introduced a new dimension, multiple results*. What I gave
was an option based on my guesses from the lines that you posted here. Check the response given in your other posting, where you had described it differently. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "I M Desperate!!!" wrote in message ... I am only getting one result, and it is repeating in the copied cells. I can look and see that there is more than 1 result, but they are not coming up. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing a value from a chart with 3 variables | New Users to Excel | |||
Lookup with Variables | Excel Worksheet Functions | |||
lookup 2 variables | Excel Discussion (Misc queries) | |||
Lookup (multiple variables) | Excel Worksheet Functions | |||
Referencing Variables | Excel Worksheet Functions |