software

I often get this problem. A long list contains partnumbers (some numerical,
some text) and I need to get price from a pricelist. Even though it is an
exact match I get #N/A in return. Only way to get it working is to edit the
source cell (F2 Enter).
I have tried TRIM() and VALUE() but since the list contains both types I get
#VALUE in return for all text cells.

Is there a way to quot;transformquot; source column so that it will work 100%?


I come across this every day. I usually just qualify my Vlookup. To do this
you enter

=IF(ISERROR(VLOOKUP(A1,C,2,FALSE)),VLOOKUP(A1*1, C,2,FALSE),VLOOKUP(A1,C,2,FALSE))

and A1 is the lookup value.
Where C is you price list.

There are more complicated ways to do it as well.quot;Tiasquot; wrote:

gt; I often get this problem. A long list contains partnumbers (some numerical,
gt; some text) and I need to get price from a pricelist. Even though it is an
gt; exact match I get #N/A in return. Only way to get it working is to edit the
gt; source cell (F2 Enter).
gt; I have tried TRIM() and VALUE() but since the list contains both types I get
gt; #VALUE in return for all text cells.
gt;
gt; Is there a way to quot;transformquot; source column so that it will work 100%?