View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Looking up multiple results with VLOOKUP

Is it possible to have VLOOKUP return multiple results? (I suspect the
answer is "No"). My "lookup table" consists of project numbers in column A
and supported systems in column B (the project number is repeated in each row
for which there is a different supported system).
If VLOOKUP can't do the job, can someone possibly show me how to write a
macro that will? I would appreciate any help.
Thanks.