Index match gives errors

[denmccue]

I am trying to write straightforward code, using web searches to pattern my line.
Cells("H2").Value = WorksheetFunction.Index(Range("P2:P284"), WorksheetFunction.Match(Cells("E2").Value, Range("O2:O284"), 0))
where H2 is the target answer here cell, P2:P284 will have the answer somewhere in that range, E2 is the cell to be matched, and O2:O284 is the range to match E2 to.
I get Run-time Error "5": Invalid procedure or call
Thanks for helping!

 

[ekrause]

You will want to tweak the Address(True/False,True/False) to lock the ranges appropriately.

Here you go:

Range("H2") = "=Index(" & Range("P2:P284").Address(False, False) & " , Match(" & Range("E2").Address(True, False) & " ," & Range("O2:O284").Address(True, True) & ", 0))"

 

[Fluff]

Hi & welcome to MrExcel.
Change both the Cells to Range.

 

[denmccue]

That fixed it. Thank you very much!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[denmccue]

That fixed it. Thank you very much!