Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup part of string...
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete a - if it is the last part of a string | Excel Discussion (Misc queries) | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
How do I use VLOOKUP to find part of string? | Excel Worksheet Functions | |||
Filter on first part of string | Excel Discussion (Misc queries) | |||
Extract Part of String | Excel Worksheet Functions |