C
caldog
I am having problems with a vlookup formula. My component for this formula
is the following. By clicking on a dropdown box, the user will select from a
list in cell [A3], then one cell over in [B3] a corresponding number will
display. Then on a separate worksheet, I have named several ranges in this
sheet. Next, I have a formula in [B4] that concatenate the word (Table) with
the information in B3. All of the above explanations are secondly formulas
to what I need for my real answer. I have a vlookup formula that uses the
cell B4 that matches my range name.
Example:
1. A3 = Toyota
2. B3 = 123
3. B4 = Table123 formula example is =concatenate
(“Tableâ€, B3)
Formula for lookup function is:
1 Vlookup(D10,B4,2)
What I want to see is a answer of say 12
But what I’m getting is a answer of (#N/A)
Can somebody help let me know what I’m doing wrong in this equation.
is the following. By clicking on a dropdown box, the user will select from a
list in cell [A3], then one cell over in [B3] a corresponding number will
display. Then on a separate worksheet, I have named several ranges in this
sheet. Next, I have a formula in [B4] that concatenate the word (Table) with
the information in B3. All of the above explanations are secondly formulas
to what I need for my real answer. I have a vlookup formula that uses the
cell B4 that matches my range name.
Example:
1. A3 = Toyota
2. B3 = 123
3. B4 = Table123 formula example is =concatenate
(“Tableâ€, B3)
Formula for lookup function is:
1 Vlookup(D10,B4,2)
What I want to see is a answer of say 12
But what I’m getting is a answer of (#N/A)
Can somebody help let me know what I’m doing wrong in this equation.