Example:

=VLOOKUP(B3,[Shona.xls]Sheet1!$A$3:$B$10,2,0)

looks up B3 in A3:A10 and,if successful, returns a value from B3:B10.

SS wrote:
Hi

I have two files one with a list in column B starting at B3.

I would like a formula that looks up this name in the other file which has a
sheet name the same and then put what is in N3.

Any ideas?

Cheers Shona