VLOOKUP not picking up all values.

[jcihak]

Hello,

I am trying to perform a VLOOKUP. It is successfully pulling most of the information, but sometimes it just skips over a value without pulling the number from the data array. I have tried messing with the formatting of the cell and checked for leading and trailing spaces. Any idea why it is missing these numbers?

thank you

 

[sheetspread]

Was the data imported? Do you have $s around the references to prevent them from changing?

 

[steve the fish]

If they are numbers it is missing it is important to know that there is a difference between an actual number and a textual number. You can test the cell using =ISNUMBER(A1) for example.

 

[jcihak]

The data is in a pivot table. Should copy and paste values to get it out of the pivot table? and I do have absolute references covering the array

 

[sheetspread]

Vlookup will work on a pivot table, but you'll have to align the data types as steve said.