You can use wildcards with VLOOKUP, so you could have:

=VLOOKUP("*"&C1&"*",A$2:B$5,2,0)

where C1 contains 994403.

Note that the table entries where there is a single employee number
(eg 994502) need to be text values in order to get an exact match.

Hope this helps.

Pete

On Oct 23, 12:46*pm, wrote:
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!