CONCATENATE within VLOOKUP

[ddudar]

I am using a VLOOKUP formula, as follows
=VLOOKUP(F390,CONCATENATE("table",M390),6)

When I use the CONCATENATE formula alone, it produces the expecte
result, which is a name for a named range found in hte worksheet.
However, used within the VLOOKUP formula, it produces #VALUE! as th
result. Error help on this formula suggests that Excel is processin
the result of the CONCATENATE function within VLOOKUP as within doubl
quotation marks (ie. "table1"), and it cannot process this.

Can anyone suggest a solution, or a workaround?

Thanks

Do

 

[Frank Kabel]

Hi Don
what are you trying to achieve with this formula?

 

[ddudar]

Frank,

I am trying to build a lookup, referring to naned ranges, where th
name range is defined as "table" plus a number found in another field.

Do

 

[ddudar]

The INDIRECT fucntion works fine.

Thanks

Do

 

[RagDyer]

Try this:

=VLOOKUP(F390,INDIRECT("table"&M390),6)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I am using a VLOOKUP formula, as follows:
=VLOOKUP(F390,CONCATENATE("table",M390),6)

When I use the CONCATENATE formula alone, it produces the expected
result, which is a name for a named range found in hte worksheet.
However, used within the VLOOKUP formula, it produces #VALUE! as the
result. Error help on this formula suggests that Excel is processing
the result of the CONCATENATE function within VLOOKUP as within double
quotation marks (ie. "table1"), and it cannot process this.

Can anyone suggest a solution, or a workaround?

Thanks

Don