Thread: quick double-criteria lookup?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robotman robotman is offline
external usenet poster
  
Posts: 51
Default quick double-criteria lookup?
OK... I added a column of helper formulas and used VLOOKUP.

Processing time is now negligable. With an unsorted list, it takes
about 0.5 seconds, with a sorted list, it's almost instantaneous.

Thanks for your help!

John






Reply With QuoteReply With Quote