ASSIGING VALUE TO ALPHANUMERIC TEXT

[OurHeroJack]

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.

 

[Joe4]

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.

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:

=D2*VLOOKUP(E2,$A$2:$B$4,2,0)

See here for an explanation and details on the VLOOKUP formula:

VLOOKUP function - Microsoft Support

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

support.microsoft.com

 

[OurHeroJack]

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:

=D2*VLOOKUP(E2,$A$2:$B$4,2,0)

See here for an explanation and details on the VLOOKUP formula:

VLOOKUP function - Microsoft Support

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

support.microsoft.com

Thanks.

 

[Joe4]

You are welcome.
Glad I was able to help!