Well, if you are OK with making a function in VB try this:
1) Make this function:
2)![]()
Option Explicit Function returnOffset(whatFind As String, whereLook As Range, offRow As Long, offCol As Long) As Variant returnOffset = whereLook.Find(whatFind).Offset(offRow, offCol).Value End Function
Call it in the sheet, like this: =returnOffset("JANUARY",A1:J100,1,0)
That should do it
Bookmarks