Dear all
I have a problem writing the indirect formula correctly so that I can drag it down i.e. automatically increase row numbers even though it refers to a range. My current syntax is like this:
INDIRECT($AS$6 &"$G" &Row()+69 &":$BB" &Row()+69)
It is integrated into an Index-match formula:
=INDEX(INDIRECT($AS$6 &"$G$72:$BB$72");MATCH(INDEX(INDIRECT($AS$6 &"$G" &Row()+69 &":$BB" &Row()+69);MATCH(TRUE;INDEX(ISNUMBER(INDIRECT($AS$6 &"$G73:$BB73"));0);0));INDIRECT($AS$6 &"$G73:$BB73");0))
I hope someone could figure this one out!
Thanks a lot!
Bookmarks