Can vlookup work using formula values?

[Larry P Clark]

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

 

[Niek Otten]

Hi Larry,

Post your formulas and input values

 

[Larry P Clark]

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]

Hi Larry,

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

 

[Dave Peterson]

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".

 

[L. Howard Kittle]

Hi Larry,

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

HTH
Regards,
Howard