Hello from Steved

In a Worksheet called 1st Week in Col "A" I have "City" and "Panmure", and
in Col "B" to Col "H" I have Data.

I would like the formula to find City in Col "A" ( 1st Week ) then From the
second Col "B" ( 1st Week ) capture the data from that cell, then find
Panmure in Col "A" ( 1st Week ) then From the second Col "B" ( 1st Week )
capture the data from that cell, and now paste the Captured Data in worksheet
Called Summary.

Thankyou