Excel match data (2 minutes through formula)

Source Data

Sheet7

• Column A: Ticker

• Column B: Date (IPO Date)

• Column C needs to be filled: Price

Sheet6

• Column A: Ticker

• Row 3: Dates (column headers)

• Rows below: Prices, where each price is at the intersection of:

  • ticker row

  • the corresponding date column

Task

For each row in Sheet7:

1. Find the same Ticker in Sheet6 in column A.

2. Find the same Date in Sheet6 in row 3 (the date format may vary — this needs to be taken into account).

3. Take the Price located at the intersection of the found ticker and date.

4. Record the found price in Sheet7 (column C).

5. If no data → output "Not found".

Anyone who knows how to work with formulas - the job will take 2 minutes.