VLookup query?

  • Thread starter Thread starter mccrimmon
  • Start date Start date
M

mccrimmon

How many cells can a look up work for?

im trying to use a look up for a set of data containing around 30,00
rows of different 7digit numbers and a stock name on the corresponden
cell beside it.

Now the problem im having is its saying scale is to large or im out o
memory.

Is there a way round this or a better mehtod than a look up to use?

Cheer
 
I suspect it is something more complex than that.

Try this routine in an empty spreadsheet; it will load 60,000 lines of data,
a lookup value and a lookup formula.

This is fine in Excel 2000 ... but there's nothing else going on.

Sub LoadData()
Application.ScreenUpdating = False
Range("A2").Value = 2
Range("B2").Value = "Description " & 2
Range("A2:B2").AutoFill _
Destination:=Range("A2:B60000"), _
Type:=xlFillDefault
Range("D2").Value = 50000
Range("E2").Formula = "=VLOOKUP(D2,$A$2:$B$60000,2,FALSE)"
Application.ScreenUpdating = True
End Sub

Regards

Trevor
 
Back
Top