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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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,653
Messages
6,120,751
Members
448,989
Latest member
mariah3

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