How to change date from numbers to words drop down menus

[dannytype1]

Hi everyone i am a bit of a novice so sorry if this is easy.

I have a group of numbers in a table of spreadsheet.

1. $100
2. $200
3. $300

In the drop-down list in the spreadsheet instead of showing $100, $200, $300 i would like it to say Bronze Silver and Gold. Obviously i still need the numbers in my table so my spreadsheet will work.

Hope that makes sense.

Many thanks

Danny Kirk

 

[Michael M]

If you need to keep the numbers, why not use in an adjacent column....AND assuming your data is an Col "A"

=LOOKUP(A1,{100,200,300},{"Bronze","Silver","Gold"})

 

[dannytype1]

Hi Michael

Thanks so much for getting back so quickly. You are correct the data in in column A and i am putting the words in column B. Where would i put =LOOKUP(A1,{100,200,300},{"Bronze","Silver","Gold"}) ?

Many thanks

Danny

 

[Michael M]

Put the formula in Column "B" and drag down as far as required

 

[dannytype1]

Can i do with define name? I have it alreadt setup in my table but when i change data validation it still shows the numbers not the words?

Thanks

Danny

 

[dannytype1]

Hi Micheal

I am still struggling to get this to work. The image on the left is the spreadsheet and the image on the right is the table. Instead of showing $10 half way done the spreadsheet i need it to say Standard in the drop down list. I have tried loads of different ways but still no joy.

Thanks again

Danny

 

[Michael M]

I seriously don't see how you could do that, except with VBA overwriting the data !!

Also, if the list in the first image is going to say standard instead of $10.....you won't be able to get a list total !!