RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello, I need help in rectifying this formula.
If the values in columns H,J and M are matching with columns A,C and F, then column H should dis[lay the same name as in column B, else display No Match.
The goal is to get the result in column H.
=INDEX($B$3:$B$16,MATCH($H3&$J3&$M3,$A$3:$A$16&$C$3:$C$16&$F$3:$F$16,0))
If the values in columns H,J and M are matching with columns A,C and F, then column H should dis[lay the same name as in column B, else display No Match.
The goal is to get the result in column H.
=INDEX($B$3:$B$16,MATCH($H3&$J3&$M3,$A$3:$A$16&$C$3:$C$16&$F$3:$F$16,0))