Vlookup with Offset

[Moonbeam111]

I'm a little bit rusty on my excel knowledge and I know this one is beyond me. And I couldn't figure it out through looking through the message boards, although there were similar topics.

I have two sheets Sheet 1 and Sheet 2 in my workbook. I have a word in range ("F7") in the first Sheet 1 that must be found within range("J1254:J1378") in Sheet 2. When it finds the value in the Sheet 2's selected range ("J1254:J1378"), I would like it to search for the first empty cell starting from the cell it found (going up, not down or across) and offset from that empty cell to the right one. Than I would like it to copy and paste that found offset value to Range ("D3") in Sheet 1. How would I go about this?

Advice would be appreciated.

 

[Peter_SSs]

I can't see how the two codes as posted in the forum can give the same results, but if you are satisfied then so am I.