Hi Larry,

Perhaps use Indirect(H1), where H1 is the concatenated cell.

HTH
Regards,
Howard

"Larry P Clark" <Larry P wrote in message
...
I'm using vlookup to insert a value in a cell. I am then cocatenating
that
cell with text from a 2nd cell to create a unique string. My third step
is
to use another vlookup (using the value from the second cell that I
concatenated) to populate a third cell with a value from a table.

This is not working (I receive the #N/A error) because my concatenate step
is using a vlookup value. Aside from copy & paste, is there a way to get
my
2nd vlookup to return a value?

Thanks,

Larry