help needed - match if

[crisb]

Please help!!!


I am currently working with this formula,

=IF(ISNA(MATCH(A2,Database!B:B,0)),"No match","") - its working well, pretty much it tells me "No match" when it can't find a value on the second column.



BUT now I also need for it to be able to discriminate between values. I want for it to be able to look into column C and match (A&B columns) if there are values in column C named "Pending 6 Months" or "Pending Acceptance"


Thanks!
Cristina

 

[Aladin Akyurek]

Please help!!!


I am currently working with this formula,

=IF(ISNA(MATCH(A2,Database!B:B,0)),"No match","") - its working well, pretty much it tells me "No match" when it can't find a value on the second column.



BUT now I also need for it to be able to discriminate between values. I want for it to be able to look into column C and match (A&B columns) if there are values in column C named "Pending 6 Months" or "Pending Acceptance"


Thanks!
Cristina

Would you elaborate a bit more - what value or values must be match against which columns and what is the column from which a result must be picked up?

The fomula you have matches A2 against column B on Data, does not pick up a result but creates one ("no match" or "").