Help with lookup (I think?)

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?
 
N

Nick Hodge

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
[email protected]
 
Top