Help with an Index/Match formula please

David G11

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

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

David G11

https://community.smartsheet.com/discussion/comment/379315#Comment_379315

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

Yamaha

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

Yamaha

Try this. I thought that are two sheets

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