VBA Offset Index Match

[leahb909]

Hi

I'm looking for a code to find a value in a range, and return the cell 3 rows above it.

This is code I have the returns the first value, I can't figure out the next bit to add in the offset.

Thank you!

Application.WorksheetFunction.Index(Sheet26.Range("A1:A10000"), Application.WorksheetFunction.Match(Sheet26.Range("D1"), Sheet26.Range("B1:B1000")))

[Phuocam]

 Application.Index(Sheet26.Range("A1:A10000"), Application.Match(Sheet26.Range("D1"), Sheet26.Range("B1:B1000")) - 3)