Check entire checkbox column for a check

Anirudh

Hi all, 

As shown in the screenshot below, I'm trying to scan the entire MR column for a check mark and if the box is checked, I would like to return the value in the Tower Status column. For example, in the case of the screenshot, I would like to return the value, "status 2". 

Only one box will be checked in the entire column at any given time. 

Thanks.

Anirudh

Nevermind. VLOOKUP worked.