G
Guest
I have a column of data that is the result of an index formula from a
different tab. I am trying to use that data in a vlookup formula, but
continue to get a #N/A error.
For example, the result of my index formula is E4736B. That shows in the
cell in column B.
I manually type in the same value in another cell, and then try to use that
cell's contents in a vlookup.
-> in cell B25 is E4736B. (result of index)
-> in cell B16 I type in E4736B.
-> in cell G16 I have the formula =vlookup(B16,B25:G35,5,false)
The formula results in #N/A.
I am guessing that this because the value in B25 is not really a value, so
it technically isn't what I asked to lookup.
Am I correct?
How do I work around this to get my lookup without converting the B25 value
from a dynamic value?
TIA
different tab. I am trying to use that data in a vlookup formula, but
continue to get a #N/A error.
For example, the result of my index formula is E4736B. That shows in the
cell in column B.
I manually type in the same value in another cell, and then try to use that
cell's contents in a vlookup.
-> in cell B25 is E4736B. (result of index)
-> in cell B16 I type in E4736B.
-> in cell G16 I have the formula =vlookup(B16,B25:G35,5,false)
The formula results in #N/A.
I am guessing that this because the value in B25 is not really a value, so
it technically isn't what I asked to lookup.
Am I correct?
How do I work around this to get my lookup without converting the B25 value
from a dynamic value?
TIA