Help with ISERROR function.

[Permagrin]

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 room. That formula shows which user is at that seat. If a device is not assigned the H column is blank.


If the device is assigned a location AND there is no one assigned to that seat I get a #N/A error.

I have been trying to use if isserror to no avail. I would like these #N/A's to say "Open Seat" if possible.

How should I correct the formula so that its blank if the device is not assigned and it shows "Open Seat" if the device is assigned to an open location.

Thanks everyone!

 

[Fluff]

Maybe
=IF(G8<>"",IFERROR(INDEX(AD_Username,MATCH(G8,AD_Locations,0)),"Open Seat"),"")