View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chrisl147 Chrisl147 is offline
external usenet poster
 
Posts: 2
Default How can I use a VLOOKUP function to search a multi-page workbook?

I regularily use VLOOKUP but want to create a LOOKUP that will search all
pages of a workbook and return the required data. I am using a distinct
customer number that will only appear once.