Hi

On one sheet i have a list of all bowlers and their average. Column A is
the Name and Column B - E is there Average for four weeks. Each week varying.

On a 2nd Sheet Is follows
A B
Week 2
Greg Hill

in B2 i need a Formula to look up the bowlers name in Cell A2 and return
their average Week 2 (Cell A1).

I am no expert in Excel but know my way around a little. Is this possible
and how do i do it.

Thanks Heaps