I am trying to write a regular INDEX MATCH formula but don't know how. Here is what I am trying to do:
(match index) In CTL File (sheet name) - - OptionID = ACT and locid = CELLN82 find LXD in Column T
CTL File is the sheet name, I want to look for (Column I) Option ID = "ACT" and (Column A) Location ID = N82 and return the (Column T) MaxLeaseEndDate(orModelExpDate)
Does anyone know how to write this formula?
(match index) In CTL File (sheet name) - - OptionID = ACT and locid = CELLN82 find LXD in Column T
CTL File is the sheet name, I want to look for (Column I) Option ID = "ACT" and (Column A) Location ID = N82 and return the (Column T) MaxLeaseEndDate(orModelExpDate)
Does anyone know how to write this formula?