Also the sheet name appears in E1 of the second file if that helps

Cheers

"SS" wrote in message
...
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