| 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 |
| 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) | |||
Threaded Mode
