Search for Value and Return a date from another cell in same column

1st post and this one is a doozy, least for me it has been.
I have a simple spreadsheet (see picture). I would like to search for a
number value (V66) in a range of cells (J15:AF15) and based on the cell
returned (X15) return the date for that column (X8) and have that date show in
(V68)
The closest I could get, and it is not proper or correct is using HLOOKUP in cell (V68)
like this:

=HLOOKUP(V66,J8:AF15,1,FALSE)

I have tried various combinations of LOOKUP, VLOOKUP, HLOOKUP, MIN, MAX, DATE and
a whole slew of other functions until I am stuck in a circular reference myself now.

Any help would be greatly appreciated, thanks,
Ray

Find Date of Specified Value.jpg

You sir are a genius! Thank you, it worked like a charm (as an array).

I could follow along with the formula as you wrote it with the exception
of references to the 16th value...I think.

MATCH(246.99,I15:AF15,0) = 16th value in from I15
Takes that value and then points at the 16th in on the '8' row = May-13?

Thank you,
Ray

Index(range,rows,columns)

We aren't using any row change, so we leave that at zero. We are however looking for which column 246.99 occurs in.

Match(246.99,I15:AF15,0) = 16, because it happens 16 columns over from I15.

So index is pulling the 16th value in I8:AF8.

Index/Match has a lot of applications, especially for reorganizing data.

When used in conjunction with RANK, you can use it to pull top X values from a table by simple matching the rank.

Almost had it
I do understand now and will keep your reply as a handy reference.

Thank you again,
Ray