Assuming names in Table 2 are in row 1 starting in column A to ?? (Z in my
example):

=HLOOKUP(A1,Table2!A1:Z3,3)

HTH

"JaB" wrote:

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