Forum Discussion

Kenz97's avatar
Kenz97
Copper Contributor
Apr 14, 2023

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.

Excel
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 14, 2023

    Kenz97 

    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)

     

    • Kenz97's avatar
      Kenz97
      Copper Contributor
      Apr 14, 2023
      I tried that. I get Install Base =75 instead of 110.24?

Resources