• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

When should I use VLookUp? When is it better to use Index and Match?

by on
in Excel Training,Office Technology

Q. When should I use VLookUp and when is it better to use Index and Match?

A. There are a lot of opinions about these functions and their use. Some people swear by one approach or the other. However, good reasons exist to use both. If your data are organized with the Lookup_value in the first column or the first row, a VLookUp or HLookUp, respectively, is perfectly appropriate. If your LookUp column is not sorted in ascending order, be sure to use 0 or False in the Range_lookUp field.

What if your LookUp_value isn’t in the first column? Then the combination of Index/Match is your go-to solution. Match looks up a value in a range and returns its relative position. Index examines a range for a value based on the relative position of the item found in the Match function. In our example, we know the product name (B9), but need the item number.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/34717/when-should-i-use-vlookup-when-is-it-better-to-use-index-and-match "

Leave a Comment