VLookup type function

  • Thread starter Thread starter Subs
  • Start date Start date
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
 
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??
 
Back
Top