Here is the formula I used:

=INDEX('Adding Funding Source'!$M$1:$M$337,MATCH(1,('Adding Funding
Source'!$A$1:$A$337=B1)*('Adding Funding Source'!$N$1:$N$337=M1),0))

Here are the columns that Match:
Column B in Wks 1 matches Column A in Wks 2 (Adding Funding Source)
Column M in Wks 1 matches Column N in Wks 2 (Adding Funding Source)
Column M in Wks 2 is the one that contains the data I would like to display
in Wks 1.

I entered the formula above based on the formula you provided, and after I
pressed Clt-Shift-Enter, I got 0. The data that should have displayed was a
text statement.

Did I do something wrong?

Thanks.

"Sheeloo" wrote:

Copy this into C1 of Sheet1 (assuming no header row)

=INDEX(Sheet2!$C$1:$C$10,MATCH(1,(Sheet2!$A$1:$A$1 0=A1)*(Sheet2!$B$1:$B$10=B1),0))

[Adjust 10 to the last row in your set]

then press CTRL-SHIFT-ENTER and copy down till you want

If sheets are in different files then you will have to add the filename
before the sheetname in []


"Ash" wrote:

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