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

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

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

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