I would like to find a formula (in Target Tab Col B) that will help lookup the lowest % based on the values in the Data Tab. The lookup cell could contain more than 1 value.
For example:
Data Tab
Col A Col B
A 50%
B 40%
C 10%
D 90%
Target Tab
Col A (set) Col B (Value)
A 50%
A, B 40% ( since A is 50%, B is 40%, it returns the value of 40%)
A, B, C 10%
A, D 50%
Thank you.
Bookmarks