VLOOKUP based on chunks of 10 rows

**Phlegon_of_Tralles** · 05-20-2019, 09:34 AM

Okay this one is a difficult one. I'm not sure if it can be done. Basically Sheet2 is a report based on access. It goes by row, so the first 10 rows belong to 'Smith, Jim'. These rows contain data that I want to put into the 'Main' tab, under each particular person.
So, for Smith, Jim on the Main tab, I want to find the following:
Name # - this correlates with the information on Sheet2, cell C2.
Company - this correlates with the information on Sheet2, cell E2.
Card # - this correlates with the information on Sheet2, cell D3.
StartDate - this correlates with the information on Sheet2, cell D5.
StopDate - this correlates with the information on Sheet2, cell F5.

I've tried Vlookups, but they don't really work. I've tried just inputting equal signs. Neither work. I'm not sure if anything WILL work - I'm out of ideas.

Does anyone have any ideas?

**KOKOSEK** · 05-20-2019, 09:47 AM

If I am correctly catch syntax/pattern of data on sheet2.
Locate row with name and grab data from other column (with shifted row number), like this for C3:

Please Login or Register  to view this content.

if needed (like dates) you have to shift a bit location to grab proper cell, like (for G3):

Please Login or Register  to view this content.

Check attached file.

**Phlegon_of_Tralles** · 05-20-2019, 10:49 AM

That totally works, but I'm not sure I understand why. What does the +1 (or +4) do? I think you say that it shifts it - so would this mean, for +1 it shifts it one row (down)? Would +4 shift it 4 rows down?