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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!