How to change date from numbers to words drop down menus

dannytype1

New Member
Joined
Jul 28, 2014
Messages
5
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
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
If you need to keep the numbers, why not use in an adjacent column....AND assuming your data is an Col "A"
Code:
=LOOKUP(A1,{100,200,300},{"Bronze","Silver","Gold"})
 
Upvote 0
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
 
Upvote 0
Put the formula in Column "B" and drag down as far as required
 
Upvote 0
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
 
Upvote 0
zyc5c.png
mju9vn.jpg


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
 
Upvote 0
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 !!
 
Upvote 0

Forum statistics

Threads
1,213,550
Messages
6,114,265
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top