View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CBI FlexCard CBI FlexCard is offline
external usenet poster
 
Posts: 1
Default Help Please - Lookup in an array that has duplicte values

I have an array with the lead column having duplicate ID #'s, but unique
related data in the array. I need to lookup all related data to the ID. In
the following example, I need to lookup ID #2 and find both Blue and Green.
Is this possible?

ID Color
1 Red
2 Blue
2 Green
3 Black

--
Bryan