Excel 2007 : VLookup with multiple sheets

[Lettin03]

afbeelding.JPGHi There,


In excell, I am using VLookup to automatically load information from another sheet. For example:

In my 'front page' I have a cell available to put in the so called 'map number' (001, 002 etc.). In another sheet, this map number has got lots of information. Untill here I know what I am doing and everything works with the following code:

=VERT.ZOEKEN($AL$2;Invoer1;3;ONWAAR)

$AL$2 = Cell to put the 'map number' in
Invoer1 = List of all map numbers and information of the first sheet
3 = Loads information of column 3 from the first sheet


However, I have 3 more series of different 'map numbers'. All on a different sheet with the same situation: A list of other map numbers (A1, A2 etc.) and its information. Is it possible to use only one frontpage and one cell to load information from different sheets? Hope the problem is clear. Thanks in advance.

Attached you can find the 'frontpage'.

[Lettin03]

This thread can be closed and deleted.