Index formula was working. Not matching now.

Robert S Fike

=IFERROR(INDEX({LNH MASTER SHEET Neighborhood}, MATCH([Job Number]@row, {LNH MASTER SHEET Job #})), "")

It was pulling from our master sheet and has worked for weeks. Not sure what has changed.

Paul Newcome

Try specifying an exact match in the MATCH function like so:

=IFERROR(INDEX({LNH MASTER SHEET Neighborhood}, MATCH([Job Number]@row, {LNH MASTER SHEET Job #}, 0)), "")

Zachary Hall

For some reason it is not finding the match. Given the screenshot there are a couple of things I can think of to check:

• Is there potentially a space included in either one of the Job # cells that could be throwing it off?
• Is the search range for {LNH MASTER SHEET Job #} an entire column or was it set to a particular range of data which may not include the requisite rows?

Robert S Fike

Thanks. Neither of those are the case. And the weird thing is, it keeps going in and out. All the data came back, and now has left again. Hmm

Paul Newcome

Try specifying an exact match in the MATCH function like so:

=IFERROR(INDEX({LNH MASTER SHEET Neighborhood}, MATCH([Job Number]@row, {LNH MASTER SHEET Job #}, 0)), "")

Robert S Fike

Seems to be working. Thanks for your help.

Paul Newcome

Happy to help. 👍️