Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.