Your vlookup should look something like:

Cells(i, 4).Value = Application.Vlookup(x, Sheets("Second").Range("A:C"), 3,
False)

--
Regards,
Fred


"Amethyst" wrote in message
...
Can anyone help me with the correct syntax for this?
I'm using Office 2003......

Here is my problem:

Ok, I start with a string of text and fill in columns using a "=mid"
formula.

finalrow = Cells(65536, 1).End(xlUp).Row
For i = 1 To finalrow
MyText = Cells(i, 1)

Cells(i, 2).Value = Mid(MyText, 18, 3)
x = Mid(MyText, 18, 3).value
Cells(i, 3).Value = Mid(MyText, 10, 2)


So I now have my value for columns 2 and 3. and I have the variable x set
to the value of column 2.

Now I want to use a "vlookup" command to search another worksheet for the
value of column 4.
(call the other worksheet, "second" and the value looking up is in sheet 1,
column "a", returning the value in column "c")

So if the value of column 4 equals "y" then

Cells(I, 4).Value = y

Next i

Thanks in Advance for all your help.....