V-Lookup Frustration

[Guest]

I am trying to do a seemingly simple V-Lookup. I am comparing 2 parts lists, and when I find a part number match, I need to get the price of the part from the adjacent column. One part list is in column A, and I have copied the other part list (with the pricing) in columns C and D. The formula I am using is: =Vlookup(A1,C11000,2,0
The problem is that the result is "#NA". I can get a correct result if I put a number of my own in the cells, but it won't seem to work on this particular list, even though the number may be the same as the one that I created in the cell myself. Is there some kind of formatting issue
I appreciate any assistance you may be able to provide
Thanks
Lanc

 

[Frank Kabel]

Hi
probably your numbers are stored as Text. Try the following:
- copy an empty cell
- select your values
- goto 'Edit - Paste Special' and choose the action 'Add'

 

[Guest]

Nice one, Frank. I've always used multiply by 1. Never thought to add zero. Happy to know it

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*-
Hope this helps
Anne Tro
Author: Dreamboat on Wor
Email: Dreamboat*at*Piersontech.co
Web: www.TheOfficeExperts.com

 

[Frank Kabel]

Hi
as I'm general a lazy type this saves the entry of 1 into a blank cell