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)
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),"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Cool, works, but could you make this IF Column B=E2 ?
In B I will have multiple numbers, selection will be at E2
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)),"")
How can a column be equal to a cell?
This?Originally Posted by ionelz
=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),"")
Thank you all, done !
You're welcome!
Please mark as solved.
You're welcome & thanks for the feedback
By the way, your title is quite misleading: this is data extraction with THREE conditions!
Yes, I was trying to pay less !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks