Matching multiple values in different rows and columns

[drakaz]

Hi,

I'm unsuccessfully trying to make up a formula that matches several values, which are not in the same row/column.
What I'm trying to accomplish, example from attached file: in Sheet2, K9 cell value should be taken from Sheet1 cell C4. So it should match "Name1", date: "2011-11" and activity "1.1.1.", but I'm lacking excel skills to make up such a formula.

Any help would be appreciated.

Regards,
d

SOLVED
Simply used index with two match functions inside and added +1 to retured value from match formula.

[Richard Buttrey]

Hi,

See attached with a new helper column in column A sheet1

Try and avoid merging cells as you've done on row 1 sheet1. Use Center Across Selection for preference. Merging cells often causes errors and problems with more complicated workbooks and is generally not recommended.