vlookup fails on data from a pivot table

[Guest]

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

 

[Roger Govier]

Hi Pat

Take a look at the GETPIVOTDATA function.
Great help can be found at http://www.contextures.com/xlPivot06.html

 

[Guest]

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

 

[Debra Dalgleish]

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