lookup of tabname in another file

[Belifahr]

disclaimer, not native English so naming may not be in accordance to the official English names.

I have two files. File A does a vlookup in File B, File B has a lot of tabs.

This is the formula:
=VLOOKUP(cel;'[File B.xls]Tab01'!range;colum;nottrue)

Simple and works fine.

However, I was wondering if i can also have incorparated in this formula the look up of Tab01 it needs to find the data on?

I have a lot of rows in File A that need to look up information in the various tabs of File B.

Looking forward to your reply!

[Pete_UK]

To do this you would need to use the INDIRECT function, which converts a text string which represents a range reference into an actual reference which Excel can work with.

One problem with this function, however, is that it only works with workbooks which are open - can you guarantee that File B will be open in the same instance of Excel?

Pete