# Add a number value to text

Hi, I am trying to figure out Excell and am very new. I am trying to design a template to do bidding for my company. I would like to have text associated with a number value to do a math formula. For instance I have A13 with a number of 8268 and B13 with the words Install Base. I would like Install Base to have a value of 75. Then I would like to divide A13 (8268) by B13 (75) to equal 110.24 displayed in C13.

8 Replies

# Re: Add a number value to text

I'd create a lookup list. In the screenshot below if has just 2 rows, but it can be much larger of course. Formula in C13:

=A13/VLOOKUP(B13,\$G\$2:\$H\$3,2,FALSE)

# Re: Add a number value to text

I tried that. I get Install Base =75 instead of 110.24?

# Re: Add a number value to text

Did you perhaps enter =VLOOKUP(...) instead of =A13/VLOOKUP(...) ?

# Re: Add a number value to text

I copied and pasted your formula and tried typing exactly what you had?

# Re: Add a number value to text

That is VERY weird.

Here is my test workbook:

# Re: Add a number value to text

Just remember I am a complete dummy with this program. Which cell do I copy and paste your formula to? I am trying C13

# Re: Add a number value to text

Yes, C13. Did you look at the workbook that I attached to my previous reply?

# Re: Add a number value to text

Yes, I did it the same way. I ended up adding a column to assign a number then do the math from there.