need help with a VBA code to search multiple criteria for singular result

**txsooner** · 08-27-2020, 04:57 PM

Hoping someone can help. I have a workbook with two sheets. The second sheet (sheet2) is my source sheet which is updated daily. In sheet1 I have Name in col A and type in col B. there are duplicate names in the source sheet but only one type per name. I need to be able to search for the name (column D in source) and match it with the type (column L in the source) to find the output for column C (column E in the source). I will then need to reference columns A, B and C to find in my source sheet, again, multiples for the name but when all three are matched the other information is accurate from source. I currently have XLOOKUP function doing all of this but having to update the source sheet daily (over 14000 lines) it takes quite awhile for the threads to calculate. I want to move all these functions to a macro module. I have one written that will search the name in column A and return information for column C but can’t figure out how to match both A and B so C is accurate and then of course use A, B and C to match other information. Please take a look at the code written and hopefully someone can help out. Thanks,