Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with VLOOKUP and pivot table
Hello - Im having a problem. Im trying to use VLOOKUP to read a cell from a pivot table then return a value from another non pivot table on another sheet. Only trouble is it always returns NA. Ive checked the VLOOKUP formular and it works so it must be a problem reading the pivot field. Can anyone help? Thanks -- LB79 ------------------------------------------------------------------------ LB79's Profile: http://www.excelforum.com/member.php...o&userid=12156 View this thread: http://www.excelforum.com/showthread...hreadid=565073 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with VLOOKUP and pivot table
I just made a test spreadsheet with pivot table and lookup table, and I can use cells from the pivot table to bring back a value from a lookup table, so you must have an error in your formula??? Send us your actual formula. -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=565073 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with VLOOKUP and pivot table
The formula im using is =VLOOKUP(C5,$A$2:$B$50,2) If I type actual data into C5 then it works, but if its pivot data it just returns NA. -- LB79 ------------------------------------------------------------------------ LB79's Profile: http://www.excelforum.com/member.php...o&userid=12156 View this thread: http://www.excelforum.com/showthread...hreadid=565073 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on pivot table results = #N/A | Excel Worksheet Functions | |||
vlookup data in a dynamic pivot table? | Excel Worksheet Functions | |||
Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
vlookup fails on data from a pivot table | Excel Worksheet Functions | |||
vlookup in a pivot table | Excel Worksheet Functions |