Forum Discussion
Matching two ranges
I'm working with two worksheets in a single workbook - I have a column of unique IDs (B) in worksheet CA Comp and need to add the Region number for each In worksheet County Reg, I have a Column w...
Hello DebS32,
It appears that the root of your problem is the following section of the formula:
"(MATCH($B2,county_reg!B:B,0),MATCH(county_reg!K2:K60,county_reg!C:C,0))"Perhaps you could elaborate on what you're trying to achieve in this section?
It appears that you are trying to match multiple criteria for the row number but I am not sure if this is what you intended.
