vlookup part of string...
On 23 Oct, 13:31, Pete_UK wrote:
You can use wildcards withVLOOKUP, 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 tovlookuppartofstring?
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 ivlookup"994403" then it should return
London
Can I do this?
vlookupfunction 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!- Hide quoted text -
- Show quoted text -
thanks Roger & Pete for the prompt reply.
It worked!! but as pointed out by Pete the single employee value
should be TEXT now how can i convert it to Text??
I tried TEXT function... but dont really understand wat shout I keep
'format text' parameter??
=TEXT(C1, ???)
or is there any other function to convert number to text?
Thanks again!!
Milind
|