Hi, I have the following formula:
=IF(INDIRECT("'"&$B2&"'!"&"$h$3")="","",INDIRECT("'"&$B2&"'!"&"$h$3"))
I need to increment B2 to B7 when I drag down but it's not working, can i place 5 in another cell and use a formula to change the B2 value to B2 and the cell reference(5)? Thanks!
=IF(INDIRECT("'"&$B2&"'!"&"$h$3")="","",INDIRECT("'"&$B2&"'!"&"$h$3"))
I need to increment B2 to B7 when I drag down but it's not working, can i place 5 in another cell and use a formula to change the B2 value to B2 and the cell reference(5)? Thanks!