How can I assign a different value to a number (for ranking)?

[rustyuser58]

I want to assign a different value to a number in order to weigh a ranking,
ie: 1=10. Can I do that?

 

[Dave Peterson]

Maybe you could insert a new worksheet and create a table that you can use in an
=vlookup() formula.

=vlookup(a1,sheet2!a:b,2,false)

 

[Daryl S]

Rustyuser58 -

You can use a separate tab in your workbook to set up the conversions. For
example:

1 10
2 15
3 50

Then in your original spreadsheet, use a VLOOKUP on your original number to
display the ranking from the separate tab. Look up VLOOKUP in Excel Help or
through the fx button to show you how.

 

[Basta1980]

Hi Rusty,

Try something with an if statement. Depends on how many weighing you do.

Regards,

Basta

 

[Francis]

I believe that this can be done
Would you provide how your data structure layout is like
and from where do you get the criteria

Pls provide a sample showing an example
--
Hope this help

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis