Help to pull date from column on another sheet?
Current Formula=IFERROR(INDEX({LastLogout}, MATCH([Full Extension Combined]@row, {Cisco Phone Subscriber Report April 2024 Range 1}, 0)), "")
I would like to match a number on the sheet with another sheet and pull the last login date from the other sheet? I am not receiving an error just an empty cell.
Answers
-
What happens if you remove the IFERROR portions of the formula?
-
I receive #UNPARSEABLE
-
Formula =IFERROR(INDEX({Cisco Phone Subscriber Report April 2024 Range 2} MATCH([Full Extension Combined]@row, {LastExtension}, 0)), "")
Question about INDEX in this formula is the column to retrieve the data from and the MATCH is the column to confirm the row and the extension match?
-
Can you show the formula in the sheet open as if you are about to edit it, and what does it output?
=INDEX({Cisco Phone Subscriber Report April 2024 Range 2}, MATCH([Full Extension Combined]@row, {LastExtension}, 0))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!