Nested vlookup in Excel? - Getting a specific number in an array

Asked Aug 24 '20 at 15:01

Active Aug 24 '20 at 15:02

Viewed 13 times

I will give an example of what I need to accomplish.

Suppose I have the following table

This table contains the Salesman ID and the Product ID that he/she sells.

I have a different database that needs to relate the amount of product any salesman sells.

That being said, suppose I need to know how many Product ID 13 did salesman ID 3 sold: that is 15.

I tried doing a combination of IF + VLOOKUP but it doesn't drill down to needed information (Vlookup will stop when it finds desired Salesman ID and will not return the desired Product ID)

Desired output should take a Salesman ID and a Product ID and return a Number of Sales of Product

I would really appreciate if someone can give me light on this. Thanks

edited Aug 24 '20 at 15:02

Scott Craner

148,073
10
49
81

asked Aug 24 '20 at 15:01

Andrés Omaña

https://i.stack.imgur.com/3JBuf.png is the link for the example of the table. Thanks – Andrés Omaña Aug 24 '20 at 15:02
1

use a pivot table with filters – Scott Craner Aug 24 '20 at 15:02
1

If you want a formula then look into SUMIFS – Scott Craner Aug 24 '20 at 15:03

Nested vlookup in Excel? - Getting a specific number in an array

0 Answers0