Lookups over muliple sheets

[don]

Hi,

Is it possible to use Vlookup and Hlookup to search for its value over
multiple worksheets in a different workbook. If so could you please
give me an example.

Also sometime ago I saw a post giving an example of an incremental
Vlookup formula which did away with the need to manualy change the
colunm index num.

Thanks for any help


Don

 

[Héctor Miguel]

hi, don !

... use Vlookup and Hlookup to search for its value over multiple worksheets in a different workbook...
Also sometime ago I saw a post giving an example of an incremental Vlookup formula which did away
with the need to manualy change the colunm index num.

- for a vlookup example, no dupes, multiple sheets [except for different workbooks] and NO 'error trapping'...
you will find what you are looking for in the following threads: -> http://tinyurl.com/zc8x8
[it works like a charm]

- for an auto-incremental column vlookup...
could you please post a more detailed explanation ?

hth,
hector.