Hello,
Thank you for reading and please kindly help.
I am trying to use the MATCH function to resolve below issue:
"Product"= A1
Product Group A Group B Status?
X 46 45
Y 42 43 YES
Z 41 40
I have a name group of "Group A & Group B" in a drop down list.
My question:
What is the function to find 43 (C3) if Status (D column) is "YES" while Group Name is "Group B" selected in the drop down list?
Thank you so much!
I think a sample file might help.
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.
sorry how to reply with a sheet uploaded?
Go advanced with your response and scroll down until you see Manage Attachments.
OK! hope it works and thank you again!
Try:
=INDEX($A$1:$D$4,MATCH("YES",$D$1:$D$4,0), MATCH(A8,$A$1:$D$1,0))
yes!!! it works!!! ｔｈａｎｋ ｙｏｕ！！！
Glad we could help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks