Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup fails on data from a pivot table
Doing a vlookup on data copied from another file(pivot table). the function
returns N/A on certain fields. It seems like the formats of these fields cannot be equalized. For example 989 (from a pivot table) does not match with 989 in another range. If I re-type over the 989, it will work. I tried formatting both rows to make sure they were the same - still did not work. Anyone experience this? Thanks for your help |
#2
|
|||
|
|||
Hi Pat
Take a look at the GETPIVOTDATA function. Great help can be found at http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "Pat" wrote in message ... Doing a vlookup on data copied from another file(pivot table). the function returns N/A on certain fields. It seems like the formats of these fields cannot be equalized. For example 989 (from a pivot table) does not match with 989 in another range. If I re-type over the 989, it will work. I tried formatting both rows to make sure they were the same - still did not work. Anyone experience this? Thanks for your help |
#3
|
|||
|
|||
Thanks but the pivot table is not really involved. One list (range) is
copied from a pivot table but that's about all the pivot tabel has to do with anything. Anyone else have any ideas? I am desperate. Thanks Pat "Roger Govier" wrote: Hi Pat Take a look at the GETPIVOTDATA function. Great help can be found at http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "Pat" wrote in message ... Doing a vlookup on data copied from another file(pivot table). the function returns N/A on certain fields. It seems like the formats of these fields cannot be equalized. For example 989 (from a pivot table) does not match with 989 in another range. If I re-type over the 989, it will work. I tried formatting both rows to make sure they were the same - still did not work. Anyone experience this? Thanks for your help |
#4
|
|||
|
|||
Excel is probably seeing the numbers copied from the pivot table as
text. There are some techniques here that you can use to convert the text to numbers, so they can be matched: http://www.contextures.com/xlDataEntry03.html Pat wrote: Thanks but the pivot table is not really involved. One list (range) is copied from a pivot table but that's about all the pivot tabel has to do with anything. Anyone else have any ideas? I am desperate. Thanks Pat "Roger Govier" wrote: Hi Pat Take a look at the GETPIVOTDATA function. Great help can be found at http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "Pat" wrote in message ... Doing a vlookup on data copied from another file(pivot table). the function returns N/A on certain fields. It seems like the formats of these fields cannot be equalized. For example 989 (from a pivot table) does not match with 989 in another range. If I re-type over the 989, it will work. I tried formatting both rows to make sure they were the same - still did not work. Anyone experience this? Thanks for your help -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
Merging Pivot Table Data | Excel Discussion (Misc queries) | |||
Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
Consolidate data from several worksheets via pivot table | Excel Worksheet Functions | |||
How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) |