From India, Jaipur

Excel: vlookup on pivot table, vlookup, pivot table
Found at Excel: vlookup on pivot table, vlookup, pivot table
Found at Google
Have a nice day.
Simhan
A retired academic in the UK
From United Kingdom
It is also very useful to find out if data exists in the reference table. E.g., if you want to find out if Revised salary is updated for all employees in the Increment sheet, you can easily do it through vlookup. If the value is not found you'll see N/A in the lookup value.
Hlookup is also very useful, it does a search across columns instead of rows.
See the attached xls for an example of vlookup.
Email: Sandeep.todi at emportant.com
From India, Pune
From Canada, Montreal