Using referenced names by formula

[Kamolga]

Hi,

I was wondering if there was a way to "build" referenced names in formula.

As an example:

I define A1:C3 as "Line1" and I have in B4 the word "Line" and C4 the number "1"

-> instead of vlookup(K1,Line1,2,false) to have someting like vlookup(K1,function(B4&C4),2,false)


Thank you in advance for your help

 

[pgc01]

Hi
Try:

=vlookup(K1,Indirect(B4&C4),2,false)

 

[jorismoerings]

Hi,

Try this: =VLOOKUP(K1,INDIRECT(B4&C4),3,0)

 

[Kamolga]

Amazing, that works perfectly...now that is saving me a lot of time. Thank you very much indeed