Hello I am trying to classify clients by either active or inactive using index match but I am stuck.
I have one workbook like this.
Active Inactive
A D
B F
C G
The other like this
Client Class
A
B
C
D
F
G
I would like to have active or inactive show up in the class in the second workbook. Any ideas?
Bookmarks