Wednesday, 14 April 2010

Excel & VLookup

After a lot of lost hair finally managed to get this working. Mistake I was making was having duplicate records in the lookup part.

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup,FALSE)

The range_lookup is the part to remeber and FALSE must be inserted otherwise it returns the nearest value it could fine.

No comments:

Post a Comment

No over 18 sites or drugs please. Comments are moderated but followed.