Spy Journal 3.0 Filtering the web for you

On 1st November at dusk we were able to see the Moon (earths main moon – we have three actually), Venus and Jupiter form a smiley face configuration.

I got this photo of the unusual event.

I had to take the gas bottle of the BBQ today to be refilled. The underside is a haven for Redback spiders.

I got some great photos before squashing them and fumigating the under BBQ areas.

See more photos by clicking Read More

The ISNA function is an Information Function. It is is used to return information about the status of a cell, or specifically another functions results. The most common use I have for this function is to validate the VLOOKUP function. If the VLOOKUP function is looking for a value that can not be found in the lookup range, then it will return #N/A as the result. Thus it is good to wrap that function in an IF Statement using the ISNA function to replace the #N/A results with something else – e.g. a text string such as “error” or maybe a zero.

=IF(ISNA(VLOOKUP(A1,$B:$B,1,FALSE))=TRUE,"error",VLOOKUP(A1,$B:$B,1,FALSE))

Remember the ISNA function returns a TRUE or FALSE. These equate to a 1 or 0 so can be used in formulas such as array formulas as well.

Theme: “Coffee and Chic Flick” night.

Details: Meeting at the Cafe next to the Southbank Cinemas for a coffee & chat & follow it up with a movie.
Movie: AUSTRALIA – starring Nicole Kidman & Hugh Jackman. www.australiamovie.com – INTENSE!
Cost: Tickets for the movie are $6.50 + the price of drinks and nibblies etc.
Date: Tuesday 16th December, 2008.
Time: 6:30pm – 11:55pm.