Vlookup

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.

Take a look here at the example https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0AsCbyg...  

Comments

Popular posts from this blog

Follow on from home automation post

Functional Filtering in Javascript

Derbyshire Dot Net Talk - Writing Robust Systems