ASSIGING VALUE TO ALPHANUMERIC TEXT

OurHeroJack

New Member
Joined
Feb 25, 2025
Messages
2
Office Version
  1. 2024
Platform
  1. Windows
I have a pricing Matrix that with numerous ALPHANUMERIC TAGS.
example BOL1, CO3, YWE6, etc...
Each of these tags are code for a percentage value.
In this case BOL1 = 30%, CO3 = 24%, and YWE6 = 21%
I want to create a spread spreadsheet for customer that only shows ALPHA CODES but when multiplied by another cell number it uses the percentage instead of the tag/code.

Hope thats clear as mud
Shows BOL1 but actually has a value of .70 fr calculation purposes.
 
Welcome to the Board!

You could set up a two column table, that has all your Alphanumeric Tags in one column, and the associated values in the second column.
You could then use a VLOOUP function to look up each Tags value, as needed, i.e.

1740505051025.png


As you can see the lookup table is in cells A2:B4.

So if we have the values in D2 and E2, to get the result in cell F2, our formula would look like:
Excel Formula:
=D2*VLOOKUP(E2,$A$2:$B$4,2,0)

See here for an explanation and details on the VLOOKUP formula:
 
Upvote 0
Welcome to the Board!

You could set up a two column table, that has all your Alphanumeric Tags in one column, and the associated values in the second column.
You could then use a VLOOUP function to look up each Tags value, as needed, i.e.

View attachment 122723

As you can see the lookup table is in cells A2:B4.

So if we have the values in D2 and E2, to get the result in cell F2, our formula would look like:
Excel Formula:
=D2*VLOOKUP(E2,$A$2:$B$4,2,0)

See here for an explanation and details on the VLOOKUP formula:
Thanks.
 
Upvote 0

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