I am trying to index a date from another worksheet with the formula
=TEXT(INDEX('JAN-APR INV'!$A:$I,MATCH(YTD!A247,YTD!A:A,0),6),"mm/dd/yy")
I want the formula to pull date based on the ID associated which is column A. The date is in worksheet "Jan-Apr Inv" row 6. It will pull the date from A247, but doesnt line up with ID on YTD worksheet.
I don't know if index match is the right formula or if another formula is needed in this situation.
=TEXT(INDEX('JAN-APR INV'!$A:$I,MATCH(YTD!A247,YTD!A:A,0),6),"mm/dd/yy")
I want the formula to pull date based on the ID associated which is column A. The date is in worksheet "Jan-Apr Inv" row 6. It will pull the date from A247, but doesnt line up with ID on YTD worksheet.
I don't know if index match is the right formula or if another formula is needed in this situation.