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