| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in Another Table | Excel Discussion (Misc queries) | |||
| Lookup only when data exists in table | Excel Discussion (Misc queries) | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| Table Lookup using two data elements | Excel Worksheet Functions | |||
| Lookup in data table - too many arguments? | Excel Worksheet Functions | |||
Linear Mode
