Posted to microsoft.public.excel.worksheet.functions

Tias

Posts: n/a

Vlookup show #N/A

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 "transform" source column so that it will work 100%?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Numbers stored as text causes problem with VLOOKUP	naclu	Excel Worksheet Functions	2	February 6th 06 09:09 AM
Numbers stored as text causes problem with VLOOKUP	bpeltzer	Excel Worksheet Functions	0	February 4th 06 08:07 PM
UDF and Calculation tree	Ken Wright	Links and Linking in Excel	1	February 6th 05 04:58 PM
Vlookup info being used without vlookup table attached?		Excel Worksheet Functions	0	January 25th 05 10:43 AM
VLOOKUP not working	Scott	Excel Worksheet Functions	3	November 12th 04 08:06 PM

All times are GMT +1. The time now is 11:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us