Use formula result in vlookup
 

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

Use formula result in vlookup
 

I suspect there are spaces or other invisible characters in B25 (check with the LEN() function), but is also think you have a
possible circular reference problem in G16

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"billinr" wrote in message ...
|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