Forum Discussion
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...
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)
I tried that. I get Install Base =75 instead of 110.24?
Did you perhaps enter =VLOOKUP(...) instead of =A13/VLOOKUP(...) ?
I copied and pasted your formula and tried typing exactly what you had?