Can you serach an array and extract a value and input that value into another cell?

hi there. what would be in other cells? you can use the MATCH formula to find a certain keyword. i used ":" in this case:
=MID(INDEX(A27:A32,MATCH("*:*",A27:A32,0)),FIND(":",INDEX(A27:A32,MATCH("*:*",A27:A32,0)))+1,100)

or even find the date format:
=MID(INDEX(A27:A32,MATCH("*/*/*",A27:A32,0)),FIND(":",INDEX(A27:A32,MATCH("*/*/*",A27:A32,0)))+1,100)

but do note that LEFT, RIGHT, and MID will make the extraction a text. Dates are better handled as numbers. to convert them, simply put double negations in front:
=--MID(INDEX(A27:A32,MATCH("*/*/*",A27:A32,0)),FIND(":",INDEX(A27:A32,MATCH("*/*/*",A27:A32,0)))+2,100)
format it as a date.
i also just realised it should be "+2" instead of "+1" since the date is 2 characters from ":"

I am just guessing that "Cell A10 varies. It appears in Cell A8:A12." means the text in A10 can appear multiple times and that you need to find the values from column K that match each occurrence. If that is the case then the following proposed solution works.
A helper column, which may be moved and/or hidden for aesthetic purposes, is added and populated using*: =SEARCH(J2,A$10:A$12)
The following array entered formula* populates H10:H12

Formula:

Please Login or Register  to view this content.

*Array entered formulas (and functions) are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.