N
nander
VLOOKUP returns #N/A
=IF(VLOOKUP(Sales!$D$3,'Incentiv
(2)'!$A$5:$G$10,6,1)>0,VLOOKUP(Sales!$D$3,'Incentiv
(2)'!$A$5:$G$10,6,1),0)
This formulae returns a #N/A When sales are 105% and below I want a
instead. What needs to be changed in the above formula?
This is the incentive(2) worksheet this formula references
Mature Store Ast Sales Office Warehouse
Store Incentive Manager Manager Associate
105% LY Sales $0.00 $0.00 $0.00
106% LY Sales $300.00 $150.00 $100.00 $50 $50
108% LY Sales $400.00 $200.00 $150.00 $50 $50
110% LY Sales $600.00 $300.00 $200.00 $50 $50
115% LY Sales $800.00 $400.00 $250.00 $50 $50
120% LY Sales $1,000.00 $500.00 $300.00 $50 $5
=IF(VLOOKUP(Sales!$D$3,'Incentiv
(2)'!$A$5:$G$10,6,1)>0,VLOOKUP(Sales!$D$3,'Incentiv
(2)'!$A$5:$G$10,6,1),0)
This formulae returns a #N/A When sales are 105% and below I want a
instead. What needs to be changed in the above formula?
This is the incentive(2) worksheet this formula references
Mature Store Ast Sales Office Warehouse
Store Incentive Manager Manager Associate
105% LY Sales $0.00 $0.00 $0.00
106% LY Sales $300.00 $150.00 $100.00 $50 $50
108% LY Sales $400.00 $200.00 $150.00 $50 $50
110% LY Sales $600.00 $300.00 $200.00 $50 $50
115% LY Sales $800.00 $400.00 $250.00 $50 $50
120% LY Sales $1,000.00 $500.00 $300.00 $50 $5