VLookup type function

Hi

Does anyone know where I can get the code to do a Vlookup, the function
would look like this

FunctionName(Lookuplist, Range, ValueToReturn)

The code would Lookup Column A which would contain various values in each
cell, say separated by a comma and if found would return the value in
Column B.

Thanking you

Subs

Hi

do you mean you have
.......A..........B
1...12,23......Cat
2....1,5,10.....Dog

and you want to find, for example, the number 5 and return Dog, or 23 and
return Cat??


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Subs" <atof31@dsl.pipex.com> wrote in message
news:eys%23B1vVFHA.3488@TK2MSFTNGP10.phx.gbl...
> Hi
>
> Does anyone know where I can get the code to do a Vlookup, the function
> would look like this
>
> FunctionName(Lookuplist, Range, ValueToReturn)
>
> The code would Lookup Column A which would contain various values in each
> cell, say separated by a comma and if found would return the value in
> Column B.
>
> Thanking you
>
> Subs
>