Which Logical Function?

Hi all,

Can you please help me on the following:

I have a range data of B1:F100 and would like to do this:

IF C1=En (on the raw n), and IF D1=Fn then Bn

(formula is on the cell A1)

Is that possible? Please help!

Thanks
Ralem

If there's only one instance then perhaps:

A1: =LOOKUP(2,1/(($C1=$E$1:$E$100)*($D1=$F$1:$F$100)),$B$1:$B$100)

IS that what you mean ?

Better to post a sample file I suspect... what are the values in B - numbers ?

Do you have duplicate matches and if so what do you want to do with the duplicates ?

Same works for the text,

Thanks a lot DonkeyOte!
Ralem