lookup data in table

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

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.
 
Use a formula like:

=SUMPRODUCT(--(A1:D100=870)*(E1:E100="Readicote")) & "/" & 870 & "/" &
"Readicote"

for each combination of type & size
 
Back
Top