Lookup using columns and rows

Hi,

Is it possible to write a lookup formula that references columns and rows where the lookup value will always be unique?

E.g. If Sheet1 A1:A10 = Sheet2 A2 and Sheet1 B1:B10 = Sheet2 C2 and Sheet1 A1:J1 = Sheet2 D2 then return the contents of the cell from Sheet1 where the references meet.

Thank you

You need to define your needs more clearly.
In the example given, Cell A1 on sheet1 is equal to both A2 and D2 on sheet2.
Post a sample excel file and you'll get help much faster.
modytrane

Thank you very much for your replies.

I actually persevered and ended up writing a formula similar to DonkeyOte's suggestion:

=IF(ISERROR(INDEX(SourceData!$E$2:$P$1000,MATCH(OrganisedData!A2,SourceData!$A$2:$A$1000,0),MATCH(G2,SourceData!$E$1:$P$1,0))),"",INDEX(SourceData!$E$2:$P$1000,MATCH(OrganisedData!A2,SourceData!$A$2:$A$1000,0),MATCH(G2,SourceData!$E$1:$P$1,0)))

Thanks again!

Hi,

E2:E1000 is text.

Thanks