Hi

I entered Employee number in E1 then used
=IF(E1="","",INDEX(B:B,MATCH("*"&E1&"*",A:A,0)))

--
Regards
Roger Govier

wrote in message
...
Hi All

Employee No.......................... Place
99440,994403,994404.............London
99442,994401,994405.............Manchester
994410..................................Leeds
994502..................................York

In above example hpw to vlookup part of string?
Each cell has multiple employee no. but i want to lookup single
employee no and it should return place.

e.g. If in above example if i vlookup "994403" then it should return
London

Can I do this?

vlookup function returning appropriate value for '994410' & '994502'
but not the rest!!

I tried FIND, SEARCH functions but these to functions are for single
cell and not for array... :(:(

Thanks!