Matching data and multiple if statements

[bjelinski]

Hello,

I have 3 columns. One has the customer ID (code A) that also has the column that tells if the customer is target or not (yes or no)-column B). In 3rd column I have another customer id Code B . Now I want to do the following. I want to match these two id’s and if they match (meaning that the code from column C can be found in the column A look at column B and if the cell value from column B is yes write TARGET (in column D) and if it is No write Not Target and If the codes don’t ,match write NOT match.

I would use If(match, but then as you can see there are to much if statements. The other idea is to replace Yes and No with Target and Not target and then in if statement use the cell value from column B.

Thanks

[NBVC]

Try:

=IF(ISNUMBER(MATCH(C2,A:A,0)),IF(VLOOKUP(C2,A:B,2,0)="Yes","Target","Not Target"),"Not Match")

copied down.

[bjelinski]

Thanks, it worked. Just quick question, when you define array by A:A , or A:B , that means that you are taking the whole column? I guess? The same effect would be if I define the whole column exactly , like $A$1:$A$10? I guess that's true.

Anyway thanks!