Forum Discussion
Excel help - dynamic worksheet
I have the formula below and I simply want the formula to apply to a different worksheet within the same workbook based on the name in column A - rather than editing the formula for each row. ACB is...
avgjoe08 Try this:
=LOOKUP(2,1/(INDIRECT("'"&A2&"'!J:J"<>""),INDIRECT("'"&A2&"'!J:J") 
Riny_van_Eekelen thanks again - slight change to what you suggested and think it is working - just needed a bracket after the J:J in the first INDIRECT reference =LOOKUP(2,1/(INDIRECT("'"&A2&"'!J:J")<>""),INDIRECT("'"&A2&"'!J:J"))