| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup -Difference between 2 versions
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)" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup -Difference between 2 versions
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. -- Cheers, Shane Devenshire "Ed" wrote: 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)" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the difference between VLookup and HLookup tables | Excel Discussion (Misc queries) | |||
| Saving Versions | Excel Discussion (Misc queries) | |||
| Please include fonts from previous versions ('98) in new versions | Excel Discussion (Misc queries) | |||
| charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
| Two Versions | Excel Discussion (Misc queries) | |||
Linear Mode
