View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default lookups with multiple possible combinations

Hi,
If you have duplicates in your "Value" column, do you want all the Category
and Number entries associated with all the instances of the value? As I
understand it, at present you only have one cell to display Category and one
to display Number, for any selection of Value. Where do you want the extra
info to display if the Value is a duplicate?
Regards - Dave.