I have a spreadsheet with a series of dates that I want to convert to a begin and end date. Then I want to take a second spreadsheet and find a price from the first spreadsheet based on the same item number and date between the begin and end date.
I tried using XLookup with arrays and multiple criteria.
Please help me create 2 formulas. On to create a begin and end date from the price list and the second to match the transactions to the price list.
Job is closed
This job is already closed and no longer accepting applicants, sorry.
