Pulling Data from Second Sheet

John Guzman

Two Sheets:

I have one sheet labeled "Permits" and one sheets labeled "Project Tracker", Each sheet has a Column Labeled "Job #" and "Permit #".

What I'm looking for is if Job # match on both Sheets in column, Permit number column on Permits sheet is copied to project tracker sheet column.

Paul Newcome

Try something like this...

=INDEX({Other Sheet Permit # Column}, MATCH([Job Number]@row, {Other Sheet Job Number Column}, 0))

Paul Newcome

Try something like this...

=INDEX({Other Sheet Permit # Column}, MATCH([Job Number]@row, {Other Sheet Job Number Column}, 0))

John Guzman

https://community.smartsheet.com/discussion/comment/289829#Comment_289829

Paul,

Thank you so much this worked perfectly, But questions. Lines that have no data to match are showing "NO MATCH", How can i change that to say " Pending"

Paul Newcome

You would want an IFERROR like so...

=IFERROR(INDEX({Other Sheet Permit # Column}, MATCH([Job Number]@row, {Other Sheet Job Number Column}, 0)), "Pending")

John Guzman

Paul,

Again Thank you for all your assistance. This worked out perfectly for what I needed to accomplish.

Paul Newcome

Happy to help. 👍️