You cannot do that with a =VLOOKUP() formula.

You will need some VBA code (User-defined function)

Cheers,
--
AP

"Neil" a écrit dans le message de
...
I am using Excel 2003 SP2 and am trying to find a way to run a look up
function on a single cell, through multiple sheets, as opposed to a normal
V
or H Look Up.

Does anyone out there know if this is possible and if so, how to do it?