Hello all.
Here is the scenario.
I am using Excel to track the inventory of desk phones(among other things)
This screenshot is row 8.
Here is what I currently have for the H Column
=IF(G8<>"",INDEX(AD_Username,MATCH(G8,AD_Locations,0)),"")
The phones are assigned to a particular seat or...