View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary Gary is offline
external usenet poster
 
Posts: 273
Default lookup data in table

I am having trouble getting a result from the table below.
I need to know how many of each Door Type and size which come from dropdown
lists and also send through a related price.



A B C D E

870 870 Readicote
720 PBAL 2
MIL 1
870 MIL 101
COLONIAL
720 1030 Readicote
870 Readicote


I need this to display as:
1/1030 Readicote
3/870 Readicote
1/720 Readicote
1/870 MIL 101
1/720 PBAL 2

Thanks in Advance.