I am trying to do a Vlookup function that will look at 2 cells on the same 
row in one tab and find that in the workbook on the other tab in the same row 
and then spit back a number from a different cell.

It's like a regular vlookup but i'm trying to search for 2 values in 2 
different cells at the same time.

Is this possible? Maybe it's not even a vlookup i should be using. 

The problem with using an if(and()) statement is i can only search for the 
combination 1 row at a time, so if it doesn't line up, i won't get a match. I 
need to search the whole workbook. 

If anyone has any ideas, i really appreciate the help!

Thanks,
Rachel

Perhaps something like:
=INDEX(Sheet2!C:C,SUMPRODUCT(--(Sheet2!A2:A100=Criteria1),--(Sheet2!B2:B100=Criteria2),ROW(A2:A100)))

-- 
Best Regards,

Luke M
"Vlookup Function" <Vlookup Function@discussions.microsoft.com> wrote in 
message news:598D2BF1-B575-43CD-939A-9CC207C3E79C@microsoft.com...
>I am trying to do a Vlookup function that will look at 2 cells on the same
> row in one tab and find that in the workbook on the other tab in the same 
> row
> and then spit back a number from a different cell.
>
> It's like a regular vlookup but i'm trying to search for 2 values in 2
> different cells at the same time.
>
> Is this possible? Maybe it's not even a vlookup i should be using.
>
> The problem with using an if(and()) statement is i can only search for the
> combination 1 row at a time, so if it doesn't line up, i won't get a 
> match. I
> need to search the whole workbook.
>
> If anyone has any ideas, i really appreciate the help!
>
> Thanks,
> Rachel 

Please note that this is an array formula. You create array formulas in the 
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to 
enter the formula. If successful in 'Formula Bar' you can notice the curly 
braces at both ends like "{=<formula>}"

returns matching value from Sheet2 colC based on the match from Sheet2 ColA 
and Col B

=INDEX(Sheet2!$C$1:$C$10,MATCH(1,(Sheet2!$A$1:$A$10=criteria1)*
(Sheet2!$B$1:$B$10=criteria2),0))


-- 
Jacob (MVP - Excel)


"Vlookup Function" wrote:

> I am trying to do a Vlookup function that will look at 2 cells on the same 
> row in one tab and find that in the workbook on the other tab in the same row 
> and then spit back a number from a different cell.
> 
> It's like a regular vlookup but i'm trying to search for 2 values in 2 
> different cells at the same time.
> 
> Is this possible? Maybe it's not even a vlookup i should be using. 
> 
> The problem with using an if(and()) statement is i can only search for the 
> combination 1 row at a time, so if it doesn't line up, i won't get a match. I 
> need to search the whole workbook. 
> 
> If anyone has any ideas, i really appreciate the help!
> 
> Thanks,
> Rachel