Return value based on 3 conditions

[Peter1973]

Hi i need a formula to :
Look in A2:A100 for cells that match D2
Then B2:B100 for cells that match D3
Then A1:Z1 for cells that match D4

and return the data from the cell that matches all 3, hope this makes sense.

 

[DanteAmor]

It's not clear what values you want as a result.
You could give an example of your data, the data you have in D2, D3 and D4 and the results you expect.

Use the XL2BB tool to put a minisheet here.

 

[hagia_sofia]

Could you please elaborate more what it is that you are looking for or even post some sample data?