View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lolly[_2_] Lolly[_2_] is offline
external usenet poster
 
Posts: 28
Default Vlookup array problem

Hi
All

My formula is like this:
Sub Create()
Range("C3:N3").Value = Application.WorksheetFunction.Vlookup(Range("A3"),
Range("450:600"), {7,10,13,16,19,22,25,28,31,34,37,40}, FALSE)
End Sub

Error which I get Is Unable to get worksheet vlookup property value...

I want to display values in cell from c3:N3 after it performs vlookup.

I have hundreds of rows.

Any help in highly appreciated.

Thanx in advance
--
Kittie