VBA IndexMatch with For Loop

[hellomycleaner]

'this code only works in the first row and gives error code 1004 application or object define error when it goes around for the 2nd time of the loop.

[Sub indexmatch()
Dim x As Long

For x = 3 To 14
Cells(x, 8) = Application.WorksheetFunction.Index(Range("b2:f2"), Application.WorksheetFunction.Match(Cells(x, 7), Range(Cells(x, 2), Cells(x, 6))))
Next x


End Sub]

I'm very new to VBA trying to learn it. please explain in detail. Thanks

[Mumps1]

You don't need to use a formula. Appropriate code will do what you want. Explain in detail what you are trying to do referring to specific cells and attach a copy of your file. This would make it easier to test a possible solution.

[hellomycleaner]

=INDEX($B$2:$F$2,MATCH($G3,B3:F3,0))
Above is the actual excel formula that I have on excel spreadsheet that I'm attaching
I'm trying to loop around the column H to find the lowest bidding vendorindexmatch_screenshot.png

[Mumps1]

Try:

Please Login or Register  to view this content.

[hellomycleaner]

Thanks! Awesome

[Mumps1]

You are very welcome.