Relational Lookup

[Excelsiordave]

Hi all,

If anyone can help me I'd be very grateful.

I'm trying to link a lookup formula to another cell in the name range section, formula is....

=if(iserror(vlookup($b$4,L4,3,false)),0,(vlookup($b$4,L4,3,false)))

Where B4 is the week number and L4 contains the name range to look up created using the formula....

="look"&l$9

Please advise where I am going wrong in the Formula. I seem to remember being able to do it before but for some reason cannot now.

Cheers,

Dave.

 

[njimack]

Maybe =if(iserror(vlookup($b$4,INDIRECT(L4),3,false)),0,(vlookup($b$4,INDIRECT(L4),3,false)))

 

[Excelsiordave]

Problem Solved, Thread may be marked Complete.

Another world crisis (in my small world) resolved by the excel user community.

Many Thanks.