If cell matches cell in another sheet, return value from a column in that other sheet

cugbug

Im working on a formula that will compare my Client ID column from my current sheet current row, to my Client ID column on my second sheet (called Production Log). When the client ID matches, I want the check date column from my second sheet to be returned.

This is my formula. It is giving me an unparseable error.

=IFERROR(INDEX(COLLECT({Production Log 1st pr date},{Production Log Client ID},HAS(@cell,[Client ID]@row)),1)"no match")

Mike TV

@cugbug

You should be able to do this with just a simple INDEX MATCH formula such as:

=IFERROR(INDEX({Production Log 1st pr date}, MATCH([Client ID]@row, {Production Log Client ID}, 0)), "no match")

Mike TV

@cugbug

You should be able to do this with just a simple INDEX MATCH formula such as:

=IFERROR(INDEX({Production Log 1st pr date}, MATCH([Client ID]@row, {Production Log Client ID}, 0)), "no match")

cugbug

@Mike TV You are simply amazing, thank you!!