Reply to thread

Message: [QUOTE="Pete_UK, post: 3837816"] Try this: =VLOOKUP(B8,INDIRECT("'"&B2&"'!A2:F17"),4,FALSE) Note that if you use named ranges for the tables then spaces are not allowed - Excel will substitute an underscore for the space. If your ranges are named uniquely (i.e. you only have one Week_3 for example) then you will not need to bother with the sheet name. So, if you have the name Week_3 in B2, and that refers to $A$2:$F$17 on the sheet named Week3, then you should be able to do it with: =VLOOKUP(B8,INDIRECT(B2),4,FALSE) Hope this helps. Pete [/QUOTE]