horizonflame
Board Regular
- Joined
- Sep 27, 2018
- Messages
- 186
- Office Version
- 2013
Hi All,
I have a column with INDEX/MATCH formula, but the match value could come from 1 of 3 possible columns. Could you help me combine the below into one formula please?
Thanks
I have a column with INDEX/MATCH formula, but the match value could come from 1 of 3 possible columns. Could you help me combine the below into one formula please?
Code:
=IFERROR(INDEX(admin!$C$4:$C$100,MATCH(C4,admin!$B$4:$B$100,0)),"0")
=IFERROR(INDEX(admin!$E$4:$E$100,MATCH(C4,admin!$D$4:$D$100,0)),"0")
=IFERROR(INDEX(admin!$G$4:$G$100,MATCH(C4,admin!$F$4:$F$100,0)),"0")
Thanks
Last edited: