#### Marco.Zingariello

##### New Member

I'm trying to use an index match formula to find an approximate date but it's not working properly any help would be greatly appreciated.

I have 2 sheets, Sheet 1 and Sheet 2. Each sheet has a list of names in Column A with a trim formula, and a list of dates in column K. I'm trying to match the name in sheet 1 with the name in sheet 2, and the date in sheet 1 in column K with the closest date in column K in sheet 2 with the matching name, but its not working.

=IF(ISERROR(INDEX('SHEET2'!K3:K37000,MATCH('SHEET1'!A3&'SHEET1'!K3,INDEX('SHEET2'!A3:A37000&'SHEET2'!K3:K37000,1),1))),"",INDEX('SHEET2'!K3:K37000,MATCH('SHEET1'!A3&'SHEET1'!K3,INDEX('SHEET2'!A3:A37000&'SHEET2'!K3:K37000,1),1)))

It is giving me dates but they don't correspond to the name I'm trying to match it too.

Thanks