View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debbie Long Debbie Long is offline
external usenet poster
 
Posts: 2
Default VLOOKUP - or a better solution

We have the need to look up a contact number on spreadsheet A and find that
contact number on spreadsheet B. Spreadsheet B may contain that same value 1
to 20 times, and we can only get it to return the first value it finds. How
do we get ALL values from Spreadsheet B to return?
--
Debbie - Applications Instructor