Pivot tables

Resolved · High Priority · Version 2010

Mon 5 Jun 2017, 16:08 Delegate Caroline said...

Caroline has attended:
Excel Advanced course
Effective Budgeting & Beyond course

Pivot tables

Can I do lookups to data in 2 different pivot tables?

Thu 8 Jun 2017, 12:22 Trainer Jens said...

RE: Pivot tables

Hi Caroline,

Thank you for the forum question.

You can lookup data in two PivotTables.

=VLOOKUP(value,IF(test,table1,table2),col,match)

You can nest a If function in the Table_Array argument in the Vlookup. If something is true the Vlookup will return the information from the first PivotTable, if not from the second PivotTable.

I hope this can help you.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 15 Jun 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

View all Excel hints and tips