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.


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.