I want to reference cells in two columns in sheet1 and when the
criteria matches cells in two columns of sheet2 I want to return the
value in the third column of sheet1 to the third column of sheet2?

Does that make sense? Vlookup won't work here because I want to match
two columns in the same array. I thought Indexing would work but I
keep coming up with an error. I also tried to do a Match/Offset
formula from Chip Pearson's website but that wasn't what I was looking
for. Any help is much appreciated.

Thanks,
Spence