Hello All,
Thanks for all the support in the past. I would like to use the following formula =INDEX(Sheet2!C:C,MATCH(1,(N2=Sheet2!B:B)*(A2=Sheet2!A:A),0) )but it seems to not function properly.
I have two worksheets open 1 and 2 = I have two criteria to match on. Column A and Column N on sheet 1. If column (a) and column N on sheet 1 matches to column (a) and column (b) on sheet 2, then return value from column (c) sheet 2, to sheet 1 column (o).
IF
Column (a) /sheet 1 matches column (a) sheet 2, but column N - DOES NOT MATCH or meet criteria of specified letters word in column "x,y,z" return sheet 2 column (e,f,g,).
Essentially I want to match on two criteria - 1 function/ return value..simple enough, 2nd function is if there is one match on criteria one but a different match on criteria 2, use a different set of data in a different column.
I can explain further if needed. Thanks again and appreciate all of you !
Thanks for all the support in the past. I would like to use the following formula =INDEX(Sheet2!C:C,MATCH(1,(N2=Sheet2!B:B)*(A2=Sheet2!A:A),0) )but it seems to not function properly.
I have two worksheets open 1 and 2 = I have two criteria to match on. Column A and Column N on sheet 1. If column (a) and column N on sheet 1 matches to column (a) and column (b) on sheet 2, then return value from column (c) sheet 2, to sheet 1 column (o).
IF
Column (a) /sheet 1 matches column (a) sheet 2, but column N - DOES NOT MATCH or meet criteria of specified letters word in column "x,y,z" return sheet 2 column (e,f,g,).
Essentially I want to match on two criteria - 1 function/ return value..simple enough, 2nd function is if there is one match on criteria one but a different match on criteria 2, use a different set of data in a different column.
I can explain further if needed. Thanks again and appreciate all of you !