VLookup type function

S

Subs

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
 
J

JulieD

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??
 
Top