Alternitive to VLOOP to display data from a Pivot table

[Shannon39]

Hi All,

I have to produce a document displaying Equipment I have in stock, What we have allocated to new clients, and then what we have on order. Currently the way it has been done is but turning the 3 tables into pivot tables. Then displaying the In Stock pivot table on my main worksheet, and then running VLOOKUP's to display the correlating data from the allocated and on order pivot tables.

I cannot combine all the pivot tables into one as the part numbers, which should be a key field, displays multiple times from my different warehouses.

Now the reason I want a different methord to displaying my data is I cannot filter my main worksheet. when I use a slice to alter the pivot table, it messes up the VLOOKUP.

Does any one have any ideas. I have 3 tables, converted into 3 pivot tables. Which we then use one pivot table and VLOOKUP.


Any suggestions how to make this data less clunky when trying to filter/slice would be awesome.

Thank you.

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you