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}))
BJTMP , you are welcome