Hi,
I need some heads up on how to combine some formulas. Here is my formula:
=INDEX(A5:T100,ROW(5:5),MATCH(L4,A4:T4,0))
Arrays are in 3 separate sheets (similar layout). Cell L3 would represent sheet name. So, whatever sheet name is in L3, formula is working with that sheet.
Thanks in advance!
Bookmarks