Posted to microsoft.public.excel.programming

[email protected] dean.brunne@lion-nathan.com.au is offline

external usenet poster

Posts: 15

Vlookup issue

I have vlookups and match functions pointing to a templated field
where the user types in the number. After the user types in the ref
number the formulas still show #N/A. The formulas will only update
for values once I use Text to Columns to change the field to General
format. Is there a way where this does not need to happen?

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
vlookup issue	Connor Doyle	Excel Worksheet Functions	2	February 4th 10 01:52 AM
another issue with vlookup	Arain	Excel Discussion (Misc queries)	2	October 19th 07 10:02 PM
Another issue with vlookup	Arain	Excel Discussion (Misc queries)	1	October 19th 07 07:15 PM
VLOOKUP issue	The Great Attractor	Excel Worksheet Functions	6	May 22nd 07 10:18 AM
VLookup Issue	Shonte	Excel Worksheet Functions	1	November 18th 05 09:26 PM

All times are GMT +1. The time now is 05:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us