View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CrimsonPlague29 CrimsonPlague29 is offline
external usenet poster
 
Posts: 18
Default VLOOKUP-common look up entry with multiple results

Hello...

I need to have the following in a file:
Order Serial #
123 ABC
123 DEF
234 GJH
234 JKI

When I vlook the order number to get the serial #'s into another file I only
get the first instance... eg if I vlook the serial #'s for order 123 I only
get ABC returned.....Is ther a way to get multiple results for common lookup
value...

Thanks