I have the following Vlookup() in place. The problem is there are multiple values it could return and as Vlookup() is designed to return the first match.
How do I get around this? Is there an alternate function to check for a match in the "range" of matchs instead of the first match.
![]()
Set lookupsht = ActiveWorkbook.Sheets("Contiguous") contig_part = Application.VLookup(body_part(1), lookupsht.Range("A1:B38"), 2, False) If contig_part = body_part(2) Then contiguous = True
Bookmarks