Hi there

In my workbook I want to construct a formula that looks for matching data in
two tables, on two different pages and returns a value, as below.

Table 1
A1 A2 A3
John Smith Eggs (Lookup)

Table 2
G1 G2 G3
John Smith Milk Sugar

I would like the formula to look in both tables, and when it finds a
matching name, to copy the value from G3 into A3.

Any ideas?

Thanks