I'm trying to fill cell based on whether one cell's data matches another's

[excelrookie82]

I have a spreadsheet (example below) with a ton of information in it where column A has a date that corresponds to a unique number in column B. Column J has some of the same numbers that are in column B. I hoping to take the date in column A that corresponds with a number in column B and insert that date in column K if the number in column J is found to match a number in column B. I've tried using IF functions but haven't had much luck. This one seems like it should be easy but I'm at a mental block. Any help is appreciated.

Thank you!

Capture.JPG

[AliGW]

Try this:

=IFERROR(INDEX(A$2:A$11,MATCH(J2,B$2:B$11,0)),"")

Extend the ranges to suit. Drag copy down.

[excelrookie82]

That was fast! You are amazing, I really appreciate it! Thank you!!!

[AliGW]

You're welcome!