Thought this might come in useful to anyone who is lacking a little Excel skill. It's one of my old favourites... the vlookup . I have uploaded it to Google Docs but the formula is the same... USE '=VLOOKUP(G5,A5:B14,2,FALSE)' The arguments are… Lookup_Value The thing you want to lookup. In the table there is a person id with our vehicle we want to check it against our person table Table_Array This is the table we want to check our value against in this case it’s the person table Col_Index_Num This is the value we want to return, in the above case we want the name from the person table so we say 2 [range_lookup] always make this false, if not it will get the closest match. We don't want that. T ake a look here at the example https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0AsCbyg...
Random things I like, normally about technology.