Forum Discussion
VLOOKUP or something else ???
I am trying to create a lookup based on years of service and performance. For example, I have data on employees that includes years of service and whether their performance is above average, average...
For such sample
it could be
=INDEX($D$8:$F$9,MATCH($C3,$C$8:$C$9,1),LOOKUP(D3,{"above average","average","below average"},{3,2,1}))
Could I chart this data based on my original example? I would like to see:
Line chart where X axis is annual salary, Y axis is years worked
First line is Upper Quartile
Second is Median
Third is lower