The array formula below does everything I want it to do but with one
annoying exception. When the value searched is not there it returns #N/A.
In my ideal world I would like it to return the word "Free" when the
value is not present. I would settle for blank but the above would be
perfect. Is there anyway within this array formula to accomodate this or
do I need to turn to code? Again I value any guidance or help.


{=INDEX(Bookings!A2:A10000,MATCH(1,(F2=Bookings!C2 :C10000)*($C$5=Bookings!B2:B10000),0))}

Graham Haughs
Turriff
Scotland