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