Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What is the main basic difference between VLOOKUP and LOOKUP in Excel?

I read the main point is that you can specify a range of columns in VLOOKUP and then pick one to return the value. However, it gets fuzzy because it kind of seems you can do something similar in LOOKUP — is it just syntax?

share|improve this question

The V in VLOOKUP stands for 'Vertical,' which implies that it will work only on columns, where LOOKUP can scan columns or rows. Note also that LOOKUP is restricted to a single column or row, not a range, as VLOOKUP (or HLOOKUP for rows) can span.

share|improve this answer

VLOOKUP can find an exact match on unsorted data or an approximate match on sorted data, but LOOKUP does not handle unsorted data, and VLOOKUP always works vertically whereas LOOKUP automatically decides whether to work vertically or horizontally.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .