Vlookup:keep cell reference as lookup criteria

[somesoldiers]

Hi Guys

please see attached a sample from a larger workbook I am working on. What i would like to do is in the Rec tab column G, keep the references from columns L & M as the Table Array and Column Index Number.
I have =VLOOKUP(F:F,L:L,M:M,0), I would like to have =VLOOKUP(F:F,whatever tab reference is in column L as table array,whatever number is in column M as index number,0).
I have included what I would like the data to look like in coulmn H but please let me know if I have not been clear enough?

thanks

Noel

[darkyam]

Try =VLOOKUP(F2,INDIRECT(L2),M2,0) in G2, copied down. It seems to work, although it appears most of your references in F don't appear in the assigned tabs yet. Also, for CSFB, you refer to column 9 column 8 has the numbers. In UBS, 8 is referred to while 9 has the numbers.

[somesoldiers]

Hi darkyam

that's exactly what I wanted

thanks a lot