More on Lookups

Posted on November 22, 2016 by

Following my recent post on nearest lookups, I came across a post from Charles Williams on the opposite problem; how to do an exact VLookup  on a large amount of data without taking all day, but still retaining the ability to return an error message if there was no exact  match.  The link is well worth a look:

VLookup tricks: why 2 VLOOKUPS are better than 1 VLOOKUP

This entry was posted in Excel and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.