Help to pull date from column on another sheet?

Ken Stowers

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.

Paul Newcome

What happens if you remove the IFERROR portions of the formula?

Ken Stowers

I receive #UNPARSEABLE

Ken Stowers

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?

Paul Newcome

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))