Help with an Index/Match formula please

David G11 · 06/07/23

Hi All,

Looking for some help with an Index/Match(if) formula please.

Basically, if the value of a cell in column 1 = the value of a cell in column 2, then return the corresponding value which is situated in column 3.

Please see attached screenshot for reference, I am working with dates across sheets.

if a cell in DATE ID = a cell in Date identifier THEN return the corresponding date which is appears in the Date column.

As always, thanks for the help.

Yamaha · 06/07/23

=INDEX({Dater}, MATCH([Date ID]@row, {Date Identifier}))

David G11 · 06/07/23

@Yamaha thanks for your help but receiving invalid ref issue now:

Yamaha · 06/07/23

=INDEX(Date:Date, MATCH([DATE ID]@row, [Date Identifier]:[Date Identifier], 0))

Yamaha · 06/07/23

Try this. I thought that are two sheets

=INDEX(Date:Date, MATCH([DATE ID]@row, [Date Identifier]:[Date Identifier], 0))

Answers