Thread: Vlookup -Difference between 2 versions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ed Ed is offline
external usenet poster
  
Posts: 279
Default 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)"
Reply With QuoteReply With Quote