Eric,

The workaheet formula
=INDEX(B1:B9,MATCH(A1,Sheet2!D1:D9,FALSE),1)
can be used in macro like this

Lvalue = Sheets("Sheet1").Range("A1").Value
Set IRange = Sheets("Sheet1").Range("B1:B9")
Set Vrange = Sheets("Sheet2").Range("D1:D9")
Set Mycell = Sheets("Sheet2").Range("D1")

Mycell.Offset(0, 2).Value = Application.WorksheetFunction.Index _
(IRange, Application.WorksheetFunction.Match(Lvalue, Vrange, False), 1)

Mike

"Eric" wrote:

Does anyone have any suggestions on how to use index function in coding macro?

myCell.Offset(0, 2).Value =
Index(B:B [under Temp worksheet],match("Industry",A:A [under Temp
worksheet],0))

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric