Getting Column number from result of a match

user_15608340 0
Viewed 36

I have a Index/Match where it returns the address of cell. I was wondering how I could extract just the column number from that?

=CELL("Address",INDEX(Sheet1!E3:AA3,MATCH(TODAY()+1,Sheet1!E3:AA3,0)))

this is my lookup and it properly returns the value. Just struggling to extract the column?

excel-formula excel
1 Answers

Put your Index formula into a column() function

=COLUMN(INDEX(Sheet1!E3:AA3;MATCH(TODAY()+1;Sheet1!E3:AA3;0)))

enter image description here

user_175168990
Related