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

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

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

Hi Larry,

What are your formulas? What are the values of the cells that are referenced
by the formulas?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Larry P Clark" wrote in message
...
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

Copy the formulas from the formulabar in excel and paste them into your follow
up.

And since your formulas will depend on values in other cells, share what each of
those cells contain:

Like:

=vlookup(a1&b1,sheet2!a:e,3,false)

A1 = "hello"
B1 = "There"

And on Sheet2 in A173, there is a value that matches that concatenated string.
It's equal to "helloThere".



Larry P Clark wrote:

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



--

Dave Peterson

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