How to use INDIRECT formula with named ranges on another worksheet

[Saaf]

Hi There,

Hope you guys are well.

Can you please help me, I have a formula (=Indirect(vlookup(J2,StudentList,2,0)&"List")).

Vlookup & StudentList,2,0)&"List" being a named ranged from sheet2.

I now want to access it on sheet1 based off the J2 value.

Can anyone please assist me?

I would appreciate it.

Thanks.

[Pete_UK]

You could probably use INDEX and MATCH, with that INDIRECT formula embodied within, but it is not very clear what you want to do, so please attach a sample Excel workbook - details are given in the yellow banner at the top of the screen.

Pete