mardi 18 juin 2019

How to check if an account nr. is in a certain top account nrs. list with Microsoft Excel 2010?

At work I have to check a certain list with account numbers against a list of our top accounts. To do this I only have access to Excel. So far I've made a formula using an IF(ISNUMBER(MATCH())) construction that I found in a tutorial. It works kinda, but its not satisfactory.

The following image serves as an example of what I'm trying to do:

Excel example

For every row in the corp accounts list I want to check if the account nr. is in the top accounts list. For this I used the following formula in the top match list:

=IF(ISNUMBER(MATCH(C2;$A$2:$A$30;0))*0,1;0)

This formula returns FALSE for account nrs. that don't match with the top account nrs. But for account nrs. that DO match it returns 0. I'd like to have it return TRUE in stead. But so far I haven't been able to get the formula to do that with my limited Excel knowledge. How would I need to alter my formula to achieve this?

Aucun commentaire:

Enregistrer un commentaire