INDEX & MATCH need to expand my formula

This is going to be complicated to explain but I'll try my best. I've attached my project to help you understand.


I have three sheets TAKEOFF, PCFB & PCFB1.

In cell G6 of the TAKEOFF sheet, I have this formula: =INDEX(PCFG!$U$6:$AA$37,MATCH(C6,PCFG!$U$6:$U$37,0),MATCH(D6,PCFG!$U$6:$AA$6,0))

I'm using this formula to return the intersecting cell on the PCFG sheet (U6:AA37) based on what I have in cell C6 & D6 of the TAKEOFF sheet.

In its current state, I have "PCFG" (a sheet name) baked into the formula. I need that part to be dynamic, based on which sheet name I put in cell B6.

The formula currently doesn't use cell B6, but I need to be able to specify a sheet name "PCFG" or "PCFG1" in B6 and have the rest of the formula pull the data from that sheet.

Can this be done?

Thanks, Richard. This works.