How to display values based on different texts from another column

Nellycorn

New Member
Joined
Mar 14, 2022
Messages
15
Office Version
  1. 365
Platform
  1. Windows
Hello,
Can anyone please help make a formula that will display various values on a column, based on different texts from another column.
Here are the texts (quotations included) and the values to display on another column based on the texts
Text=Value
"00"=300
"0"=360
"1"=420
"2"=420
"3"=420
So far the this the only formula I figured out that managed to make this work:
1647284457245.png

1647284397735.png

But because I added + in the formula, the value for "0" gets added with the value of "00". e.g the value for "0" is 360 and the value for "00" is 300,
when I type 300 as the value for "00" in the formula, it shows in column B as 660 because the value from "0" is adding to the value of "00".
However, I just want a formula that would automatically display the right values on Column B, based on the text from Column A. Please help, I would really appreciate it.
 
Hello, yes I did try both and yours did work :D. Thank you so much, you have relieved me from the ton of further stress from out the formula myself <3
*from the hours and ton of further stress from working out the formula myself :)
 
Upvote 0

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
You are welcome.
Glad we were able to help!
 
Upvote 0
Hello, yes I did try both and yours did work :D. Thank you so much, you have relieved me from the ton of further stress from out the formula myself <3

You're welcome, thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,214,920
Messages
6,122,276
Members
449,075
Latest member
staticfluids

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