Hello,
I would like to see what function you all would suggest to use for looking up a moving range of data based on date range of i.e rolling 30 days? Would it be an index match or vlookup etc.? For example I have a list of data in column cells that will be unique for that month but would have been used numerous times in prior than 30 days.
What I want the formula to do is when I type a unique identifier i.e XLTI4021 I want it to reference or "scan" a column next to it for todays date and the 30 days prior and highlight the cell in the column its looking up that way I know that the value I typed in (XLTI4021) has a match in the column next to it. There are also may be multiple data sets in each cell for the column its looking in. I.e the column being looked at may have up to 6 unique identifiers (XLTI4021, TVXA1245, XLTI8754, TVXA4589 etc..) Please let me know what you would use to perform this function. Thanks.
I would like to see what function you all would suggest to use for looking up a moving range of data based on date range of i.e rolling 30 days? Would it be an index match or vlookup etc.? For example I have a list of data in column cells that will be unique for that month but would have been used numerous times in prior than 30 days.
What I want the formula to do is when I type a unique identifier i.e XLTI4021 I want it to reference or "scan" a column next to it for todays date and the 30 days prior and highlight the cell in the column its looking up that way I know that the value I typed in (XLTI4021) has a match in the column next to it. There are also may be multiple data sets in each cell for the column its looking in. I.e the column being looked at may have up to 6 unique identifiers (XLTI4021, TVXA1245, XLTI8754, TVXA4589 etc..) Please let me know what you would use to perform this function. Thanks.
