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