Forum Discussion
NEED HELP creating a formula
I'm working on an excel spreadsheet and I'm having trouble creating a formula. For someone that uses excel a lot, I'm sure it's easy. Let's see if I can explain...I'm trying to tell cell #1 that IF c...
I understand the organization of the data, sorry for that. First, I truly appreciate your response, thank you so much. However, this did not work. If you look on tab ALL EMPLOYEES you will see that "Additives" were not hit as the goal was 3 but the additives sold were 0. On the PAYOUT tab he should not have received $25.
Sorry, forgot about goals limit concentrating on CC.
You may wrap previous formula with if goal met or not, like
=IF('All Employee'!F4>=F$1,IFNA(INDEX(Categories!$M$2:$O$20,MATCH(F$2,Categories!$I$2:$I$20,0),LOOKUP($E3,Categories!$L$1:$O$1,{0,1,2,3})),0),0)
To simplify I took data from related All Employee cell (much better INDEX/MATCH employees by ID or another unique field) and took Goal from Pay Out tab (Goals are repeating here from Categories, better to lookup them based on category abbreviation).