HLOOKUP Question

[DayTrading]

Hey guys,

I have two files, the first file has 300 or so unique lookup codes. The second file has 12 sheets, within which those 300 codes will appear only once. Is it possible to have hlookup search different sheets on a different file? I can't use INDEX because the second file won't always be open.

If it needs a macro that isn't overly-complex then I would be open to that. If I haven't given enough info for some advice, let me know.

Thanks

 

[DayTrading]

Any one?