Nested If Contains Function Returning #No Match

Garrett.Ricker

Yes, this is a process where the same DC name will not always be in the same row.

Garrett.Ricker

The same DC names will not always be in the same row so we need to be able to identify which DC in the DC name field to direct the Vlookup to the correct sheet.

Garrett.Ricker

After talking to the support team, the issue was with the DC Location segment. ([DC Location]:[DC Location]), which was looking at the entire row, should have been looking at the cell in that row, [DC Location]@row).

Thank you for everyone's assistance on this.

Paul Newcome

Glad you got it sorted. That's what I was thinking and why I asked about it.