Get pivot data & vlookup with multiple criteria

excel pivot excel-formula pivot-table

You can use a standard FILTER function and multiply the two criteria to get your filter list

=FILTER(B1:B7,(A1:A7=123)*(C1:C7=2))

Related

multipart upload to S3 with Django-storages
How do I determine a good Babysitter?
Were shiny Ditto more likely to produce shiny offspring?
AI Civ having another civ's specialty unit
Do Side Missions ever affect Main Objective in Batman: Arkham City?
Any use other than selling for items whose 'Recommended Use' is 'Sell"?
Why do generation 3 Pokemon games run after the battery has died?
How do I tell when I'm stealing things?
Are portal keys sharable across factions in Ingress?
What does 100% Paragon or 100% Renegade actually mean?
How does Reputation work in Heroes VI? (Blood and Tears)
Are any important NPCs doomed to die, or immune from death?