Help with an Index/Match formula please
![David G11](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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.
Answers
-
=INDEX({Dater}, MATCH([Date ID]@row, {Date Identifier}))
-
@Yamaha thanks for your help but receiving invalid ref issue now:
-
=INDEX(Date:Date, MATCH([DATE ID]@row, [Date Identifier]:[Date Identifier], 0))
-
Try this. I thought that are two sheets
=INDEX(Date:Date, MATCH([DATE ID]@row, [Date Identifier]:[Date Identifier], 0))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!