Extract Data, one condition !

[ionelz]

I want to extract data to corresponded row and column.
If Column B = E2 , then extract Column E to corresponded row and column, see H5
I was trying at H5 (without E2 condition) but formula do not move to right !
In column B I will have multiple E2 (now I have only one)

[AliGW]

INDEX MATCH MATCH needs a matrix. Try this instead:

=IFERROR(LOOKUP(2,1/(($C$5:$C$388=$G5)*($D$5:$D$388=H$4)),$E$5:$E$388),"")

[ionelz]

Cool, works, but could you make this IF Column B=E2 ?
In B I will have multiple numbers, selection will be at E2

[Fluff13]

How about
=IFERROR(INDEX($E$5:$E$388,MATCH($E$2&"|"&$G5&"|"&H$4,INDEX($B$5:$B$388&"|"&$C$5:$C$388&"|"&$D$5:$D$388,0),0)),"")

[Pepe Le Mokko]

How can a column be equal to a cell?

[AliGW]

Cool, works, but could you make this IF Column B=E2 ?

This?

=IFERROR(LOOKUP(2,1/(($B$5:$B$388=$E$2)*($C$5:$C$388=$G5)*($D$5:$D$388=H$4)),$E$5:$E$388),"")

[ionelz]

Thank you all, done !

[AliGW]

You're welcome!

Please mark as solved.

[Fluff13]

You're welcome & thanks for the feedback

[AliGW]

By the way, your title is quite misleading: this is data extraction with THREE conditions!

[ionelz]

Yes, I was trying to pay less !!!