Vlookup -Difference between 2 versions

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I have seen the use of the following 2 versions of VLOOKUP and would like to
know the difference in the # of cells searched:

A. "=VLOOKUP(A6,'PPR Data'!B1:J10,9,0)"

B. "=VLOOKUP(A6,'PPR Data'!B:J,9,0)"
 
Hi Ed,

It is my understanding that the B:J entry will cause Excel to check every
entry in column B until it finds a hit and if it doesn't find a hit it would
search every entry. - 65,535 or in Excel 2007 ~1,048,000 items.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup Different tabs based on Dates 5
Vlookup with AND, OR IF statements 1
convert vlookup formula to link formula 0
vlookup ignoring empty cells 6
vlookup 1
Vlookup 6
Average of Vlookup data 3
Vlookup Problem 7

Back
Top