multiple lookups and pivot table

bobbuilder123

New Member
Joined
Mar 7, 2019
Messages
1
Hello you lovely people,

I need your help.

Sheet 2, I need to lookup up cell A4,E1 and E3 from the pivot table on "pivot" tab, to display the result in cell E4.
I then need this formula to be able to be replicated by dragging it to the right and down.

I hope that makes sense?
How do I upload a file?

Thanks
BoB
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,109,456
Messages
5,528,864
Members
409,842
Latest member
mfernandezcean
Top