VLOOKUP more than one instance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vlookup Help 0
Involved VLookup Function 6
nested if doesn't work 1
vlookup more than 2 range 2
Vlookup - ISNA function 4
Vlookup with Pivot Table 1
Limitation of Nesting of Function 3
Countif/Vlookup 2

Back
Top