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