| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP more than one instance
Formula Below:
I am looking up a product number (Cell $A416 in formula below) and returning its corresponding inventory count. The problem I have is the product number may appear more than once in the lookup range. My formula is only giving the first occurance - its not adding the count for all instances. Incidently, I get back alot on NA's, that is why I have the ISNA part. Any help? IF(ISNA(VLOOKUP($A416,'I631_2 sales'!$A$10:$D2671,4,FALSE)),"0",(VLOOKUP($A416,' I631_2 sales'!$A$10:$D2671,4,FALSE))) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP more than one instance
Try:
=SUMPRODUCT(--('I631_2 sales'!$A$10:$D2671=$A416),('I631_2 sales'!$D$10:$D2671)) tojo107" wrote: Formula Below: I am looking up a product number (Cell $A416 in formula below) and returning its corresponding inventory count. The problem I have is the product number may appear more than once in the lookup range. My formula is only giving the first occurance - its not adding the count for all instances. Incidently, I get back alot on NA's, that is why I have the ISNA part. Any help? IF(ISNA(VLOOKUP($A416,'I631_2 sales'!$A$10:$D2671,4,FALSE)),"0",(VLOOKUP($A416,' I631_2 sales'!$A$10:$D2671,4,FALSE))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First Instance | Excel Discussion (Misc queries) | |||
| How do I get rid of a 2nd instance (xls:2)? | Excel Discussion (Misc queries) | |||
| Vlookup adding more than one instance | Excel Discussion (Misc queries) | |||
| Vlookup to find Second INstance | Excel Worksheet Functions | |||
| Return only one instance | Excel Worksheet Functions | |||
Hybrid Mode
