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 wrote in
message ...
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$1 0=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