- Thread starter Wskip9449
- Start date

Sorry I’m not getting this haven’t worked with Excel in 9 years. a little rust.Wskip9449

Your formula has refer to`[@Date]`

... of course, its original value could be ... anywhere.

Have You tried to solve Your formulas`INDIRECT`

-value?

... as I tried to give a hint with my #4 reply.

Hi,

This part of your formula : =MID(CELL("filename",A3),FIND("]",CELL("filename",A3))+1,255)

Return current Sheet name

Thus, your formula :

=IF(INDIRECT(MID(CELL("filename",A3),FIND("]",CELL("filename",A3))+1,255)&"[@Date]")="","","Drone Service")

Is equal to >>

=IF([@Date]="","","Drone Service")

Then,

What you're trying to do ?

You're going to explain that a little more clearly by attach a small example attachment together with the expected result.

Regards

This part of your formula : =MID(CELL("filename",A3),FIND("]",CELL("filename",A3))+1,255)

Return current Sheet name

Thus, your formula :

=IF(INDIRECT(MID(CELL("filename",A3),FIND("]",CELL("filename",A3))+1,255)&"[@Date]")="","","Drone Service")

Is equal to >>

=IF([@Date]="","","Drone Service")

Then,

What you're trying to do ?

You're going to explain that a little more clearly by attach a small example attachment together with the expected result.

Regards

Last edited: