VLookup Syntax

[ketbdnetbp]

The following code is part of a loop but, it is not working. I believe its a syntax problem, any suggestions...
If Worksheets(iDSK2).Cells(intRow, 5).Text = "Associate" Then
Worksheets(iDSK2).Cells(intRow, 24).Select
ActiveCell.Formula = "=VLOOKUP(CONCATENATE(A" & intRow & ", "" "", B" & intRow & "),Sales!$A$6:$J200,4,FALSE)"
Else
Worksheets(iDSK2).Cells(intRow, 24).Select
ActiveCell.Value = "0.00"
End If
Dim valCheck As String


valCheck = Worksheets(iDSK2).Cells(intRow, 24).Text
If valCheck = "#N/A" Then
Worksheets(iDSK2).Cells(intRow, 24).Value = 0
End If

[Pecoflyer]

I'm not versed in VBA ( and actually this is a non VBA forum) but what is CONCATENATE(A" & intRow & ", "" "", B" & intRow & ") supposed to do ?

Non VBA syntax is =concatenate(string1,string2, etc..) or without the concantenate function = string1&string2&...

[p45cal]

try:

  If .Cells(intRow, 5).Text = "Associate" Then
    .Cells(intRow, 24).Formula = "=VLOOKUP(CONCATENATE(A" & intRow & ", "" "", B" & intRow & "),Sales!$A$6:$J$200,4,FALSE)"
    If .Cells(intRow, 24).Text = "#N/A" Then .Cells(intRow, 24).Value = 0
  Else
    .Cells(intRow, 24).Value = "0.00"
  End If
End With

but…
wouldn't, in cell X7 (just as an example row) the formula:

=IF(E7="Associate",IFERROR(VLOOKUP(CONCATENATE(A7, " ", B7),Sales!$A$6:$J$200,4,FALSE),0),0)

do the same thing without any vba at all?