Thanks but that I believe is just a normal lookup.

I'm trying to return the information that is always in N3 in each of the 150
sheets the lookup value goes from b3 to b150. It may not be a lookup at
all.

I know it could be done with paste link but I'm trying to avoid doing this
from a 150 sheets.

As I said the sheet name also appears in E1 on each sheet.

Thanks Shona

"Aladin Akyurek" wrote in message
...
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: