Vlookup help for large amounts of stock data

excelledsoftware · #5 09-18-2012, 09:56 PM

Quote:

Originally Posted by Pecoflyer

Does the attached help?

be aware that the formula is an array formula to be committed with Ctrl+Shift+Enter

Here is my suggestion to fix the issue you are having. See the edits I made in blue. You could write the formula in column A all the way down and then hide column A then the edited formula would work no problem.

Let me know if this fixes the issue or if you need a different route.

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
indent alternate lines by different amounts	rufusfrog	Word VBA	5	02-25-2012 03:36 AM
Charting Help - Stock Prices	Ligerdub	PowerPoint	0	01-03-2012 04:59 AM
Stock levels	RobertH	Excel	5	01-24-2011 01:02 PM
chart from large data set	mcfie	Excel	1	09-19-2010 03:11 AM