populate location from cell contents??? (second attempt at explaining) sorry

[Brightspark98]

Bear with me!! I think I am explaining what I need to know.....

Lets say we have several workbooks named -Premier, Championship, First, Second. And each of those workbooks has sheets called League, Players, Results.

If I enter Premier in cell A1 in a further work book, and League, in cell A2 in the same book. How can I get cell A3 to display the contents of cell A1 from the workbook populated from the contents of cells A1 & A2?



Hope this makes sense..

I would like to do this using excel functions only if possible.

Thanks in advance..

Excel 2007

 

[Mike Blackman]

Please don't re-post:- http://www.mrexcel.com/forum/showthread.php?t=557422