Vlookup #N/A to 1

[Goslingjc]

Hi,

I am using this formula:

=IF($I$6>=VLOOKUP($I$9,CurrentBookings,3,FALSE),IF($I$6<=VLOOKUP($I$9,CurrentBookings,4,FALSE),VLOOKUP($I$9,CurrentBookings,10,FALSE),""),"")

To see if a room is booked or free, however when no value is found it will display #N/A and for my purposes i need it to display 0.

I have tried isna, but couldn't really understand how to use it.

Any help would be great.

Jim

[martindwilson]

you have 2007 use iferror its easier
iferror(IF($I$6>=VLOOKUP($I$9,CurrentBookings,3,FALSE),IF($I$6<=VLOOKUP($I$9,CurrentBookings,4,FALSE),VLOOK UP($I$9,CurrentBookings,10,FALSE),""),""),0)