Formula help: Index and Match with Or

[gd6noob]

Hi guys,

I have a formula that requires an OR function but I cant get it to work.

PL_WIP v4.0 (Make Copy).xlsb
	C									L						R
1	Login									Type of leave						PL/FRL
2	adilrauf									Provincial Leave						4
3	adilrauf									Family Responsibility						4
WIP

Cell Formulas
Range	Formula
R2:R3	R2	=IFERROR(INDEX('PL Balances Converted'!$B$2:$G$10000,MATCH(C2,'PL Balances Converted'!$A$2:$A$10000,0),MATCH(Setup!$Q$8,'PL Balances Converted'!$B$1:$G$1,0)),"Not Used")

the Setup tab contains these at Q8 and Q9. The use would depend on the region.
West coast used Family Responsibility.
East coast uses Provincial Leave.

Thanks in advanced.

 

[jasonb75]

Maybe

=IFERROR(INDEX('PL Balances Converted'!$B$2:$G$10000,MATCH(C2,'PL Balances Converted'!$A$2:$A$10000,0),IFERROR(MATCH(Setup!$Q$8,'PL Balances Converted'!$B$1:$G$1,0),MATCH(Setup!$Q$9,'PL Balances Converted'!$B$1:$G$1,0))),"Not Used")

 

[gd6noob]

This is the Balances tab.

Column D header can either be Family Responsibility or Provincial Leave.

PL_WIP v4.0 (Make Copy).xlsb
	A	B	C	D
1	Row Labels	Bereavement	Medical Waiver	Family Responsibility
2	rbmurr	Not Used	Not Used	4
3	Franclav	Not Used	Not Used	4.5
PL Balances Converted

I didnt want to hardcode the columns in case there are additional columns that could added in error and would mess up the balance.

 

[jasonb75]

Did you try the formula that I suggested?
Did it work?
If not, what did it do wrong? What is in Q8? What is in Q9?

 

[gd6noob]

Hi @jasonb75, sorry we must of posted at the same time and I missed it..

I tried your formula and it worked.. awesome thanks.