So I know VLOOKUP gathers data from the first column of a table, and HLOOKUP gathers data from the first row of a table. But can LOOKUP just basically do both of those things at one time? And if so, why don't more people just use that since it can gather data from basically anywhere you want?
The main thing that VLOOKUP() and HLOOKUP() [and INDEX(...,MATCH())] can do that LOOKUP() cannot is the "exact match" lookup option. LOOKUP() can only use a "binary" approximate search algorithm on a sorted list. When you need an exact match search on an unsorted list, LOOKUP() cannot help you.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks