Finding the cell address and value in a range

[nyxcirce]

Hello everyone -

I am trying the find the value and/or the cell address of data in P1 in a range of cells (a3:n72).

Can somebody help me with a formula to get either?

Thanks in advance.

[nyxcirce]

Here's a screenshot of the sheet i'm working on.

Sheet Schedule.jpg

Say, I need to find the cell address/value of the dates in COLUMN P in the range A3 to N72 and have them reflect in COLUMN V.

Thanks again for the help.

[boddulus]

Hi nyxcirce,

The screenshot you provided is very vague, if it is possible can you post the workbook . so that we can have a clear understanding of your problem.