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!
Bookmarks