Hi. I have a code that searches in a range for a value and returns the matching value from a matching column. I want to know how I can ignore searching in one of the 3 columns in the range as it can have duplicates from the column I need and it returns unnecessary data. In this example I need to ignore column C. Column B and E are the two I really need. I have a value in cell K3. It tries to find it in column E and returns the value in column B. The part of the code for the range is this. Any help is appreciated. Thanks!
VBA Code:
Set rngSrch = srcWs.Range(“B2:E” & LastRow1)