Help with lookup (I think?)

  • Thread starter Thread starter mmeyer
  • Start date Start date
M

mmeyer

I am trying to do something simple, I think.
I have a column that a user can enter a vlue in that
could range from 0-5,won,lost (at random) and I want to
associate a percentage to each value so that when someone
enters one of the original values in the first column the
second column automatically shows the related percentage.

Any ideas?
 
Lots of ideas but specifics would depend on the spreadsheet makeup

You could use VLOOKUP, with a table of the value/percentages elsewhere on
the sheet or another sheet. You could use INDEX or MATCH or You could use a
series of IF functions if there are only six possibilities.

If you want to use VLOOKUP and your lookup value is in A1, you lookup table
in E1:F6, (E column has the original figure, F has the percent, then it
would look like this

=VLOOKUP(A1,$E$1:$F$6,2,FALSE)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top