Hi, Niek,

Thanks for the quick reply.

Unfortunately, I'm not sure what you mean by "post your formulas and input
values." Can you please explain in a little more detail?

Thanks,

Larry

"Niek Otten" wrote:

Hi Larry,

Post your formulas and input values

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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