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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,114,580
Messages
5,548,866
Members
410,881
Latest member
toonces
Top