FORMULA TO GET THE LICENSE OF ACTIVE MAILBOX

[Marvin Oco]

what is the formula to get the license assigned to the active mailbox based on data from column A and B? please see attached excel. thanks

[#2 · Accepted solution]

If I understand correctly, I believe this will work for you.
=INDEX($A$2:$A$24,MATCH(C2,$B$2:$B$24,0))

[#3]

@JMB17worked like charm. thanks!

[#4]

You're quite welcome.

[#5]

@Marvin Oco 

As a comment, on Excel with dynamic arrays that could be

=XLOOKUP(C2:C13,B2:B24,A2:A24,"")

to return entire range at once. Or, to make it more dynamic

=XLOOKUP(C2:INDEX(C:C,XMATCH(,C:C)-1),
         B2:INDEX(B:B,XMATCH(,A:A)-1),
         B2:INDEX(A:A,XMATCH(,A:A)-1),""
)