I'm looking for a formula that will save me a ton of time weekly on my reports. what I would like it to do is search in seq. to match A1&B1 from sheet1 to sheet two in the same workbook. Then return C1 from sheet1, to C1 in sheet2.
ex:

=IF(Origin+Dest Sheet1) = Origin+Dest Sheet2) return(Rate Sheet2) , Rate Sheet1.

Thanks in advance for the help!