Hi working fairly new to working with the Index/Match function. I have a worksheet that I would like to return the second row of data and also be able to drag the formula down and across to populate the data.
Attaching spreadsheet in starting with column Q to AN on the Report would like to match based on column b (store #) and return the date from the same week (columns N-AK) on the PUC tab that would be in the row where the Actual Receipt Date is.
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.