ExcelBanter - lookup data in table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - lookup data in table (https://www.excelbanter.com/excel-discussion-misc-queries/255571-lookup-data-table.html)

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.

lookup data in table

Use a formula like:

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

for each combination of type & size
--
Gary''s Student - gsnu201001

"Gary" wrote:

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.