naseerrahaman
New Member
- Joined
- Nov 25, 2012
- Messages
- 8
- Office Version
- 2019
Hi Team,
I am looking for the formula where if lookup value matches the lookuparray then formula should pick the max value for the match and return corresponding value.
for better understanding please refer the attached excel file.
Note: cross posted here
I request you to kindly look into this and advise.
Thank you.
Regards,
Rehaman
I am looking for the formula where if lookup value matches the lookuparray then formula should pick the max value for the match and return corresponding value.
for better understanding please refer the attached excel file.
Max value lookup.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Lookup value | Vookup Array | Matched | Result from column E | Based on Max Value | ||||||||
2 | Rehaman | Rehaman | 20 | A | Rehaman | B | 90 | ||||||
3 | Naseer | Rehaman | 90 | B | Naseer | H | 100 | ||||||
4 | Rehaman | 80 | C | ||||||||||
5 | Rehaman | 30 | D | ||||||||||
6 | Naseer | 1 | E | ||||||||||
7 | Naseer | 2 | F | ||||||||||
8 | Naseer | 8 | G | ||||||||||
9 | Naseer | 100 | H | ||||||||||
10 | Naseer | 67 | I | ||||||||||
11 | Xyz | 9 | J | ||||||||||
12 | Xyz | 8 | K | ||||||||||
13 | Xyz | 10 | L | ||||||||||
Sheet1 |
Note: cross posted here
I request you to kindly look into this and advise.
Thank you.
Regards,
Rehaman