See
http://www.contextures.com/xlFunctions02.html#Range
You would set up your table like this:
0% Monitor
75% Fair
90% Good
100% Excellent
Say this table was in J2:K5 and the percentage you wanted to look up was
in D2 your formula would be:
=VLOOKUP(D2,$J$2:$K$5,2)
Hope this helps
Rowan
spezialize wrote:
I also am having trouble creating a vlookup table... ive read
documentation but it isnt flying with me..
• Add a column for “Ranking” based on percent of goal reached using a
vlookup table
create the table where those selling over 100% of target goal get
Excellent, those from 90-100% get Good, from 75-89 get Fair and any
below 75% get Monitor