Creating Heat Map. Percentage formula help needed..

[Kristylee0228]

I am creating a heat map based on employee performance. I am having trouble getting the formula to give me the return I want.
What I am looking for is this: If accounts placed in August are 20% more than the accounts placed in July, = "p". If accounts placed in August are less than 20% than July,= "q". Anything in between would = "n".
Thanks for any help!!

 

[shg]

=lookup(august/july, {0,80,120}%, {"q","n","p"})

 

[Kristylee0228]

I have never used the lookup function before.
What exactly does that do?

 

[shg]

As constructed, it looks up the ratio of the August sales to July sales in the first vector, and then returns the value in the corresponding position in the second vector.

 

[Kristylee0228]

So sorry about duplicate post.
I am under pressure here and i didn't think you understood my first question.

 

[Kristylee0228]

Is it looking for the words August and July in my worksheet? Do I need to change column names?

 

[shg]

No, july and august would be replaced by references to the cells where those numbers appear.