Automate lookup based on multiple criteria

[megera716]

I have a pivot table of data and I want to use a formula in another spot to look up the data in that Pivot so I don't have to manually copy the data.

This is my Pivot:

I'm putting the data on a consolidated dashboard of sorts that has columns for each month. The formula I want to put elsewhere is essentially a lookup if the Business Unit is "Vendor" AND the Report Type is "Tier 4", return the Jan column (so the result would be 2). And then just drag it across so it returns Feb, Mar, Apr, etc. etc.

 

[Dave87]

if possible, beside the pivot table can you add a concatenate formula to make "VendorTier 4" a value, then lookup this with either index/Match or Vlookup