Hi Ash,

Use a helper column
Concatenate A and B in that column and use the concatenation of the search
arguments in VLOOKUP

"Ash" wrote in message
...
I have data in two worksheets that I would like to compare/link. To keep it
simple, suppose Wks 1 has 2 columns of data and Wks 2 has 3 columns of
data.

Columns A and B in both spreadsheets have like data. And for every row
that
exists in Wks 1, there is an match (with respect to columns A and B) in
Wks 2.

Wks 1: Wks 2:
A B A B C
Story 2 Story 1 Red
Story 1 Story 2 Blue
Apple 3 Candy 1 Red
Candy 1 Apple 3 Red

I would like to populate Column C in Wks 1, with the corresponding data in
Column C from Wks 2.
So if, column A matches, then if column B matches, then C. If at any
point
it doesn't match, it should continue looking for the matching A/B
combination
to get C.

I hope this makes sense. I think I'm really having a blonde moment.

Thanks!
Ash