Hi Krishna, see file attached, in that second sheet u see in b column i used Left function and in c column Vlookup
left function i used =left(A2.13) and vlookup answer is #N/A Because In System Data sheet Left function answer is not there if i decrease the no's in left function i ll get the answer likewise till i get answer i have to decrease the no in left function hope u understand now data will be very huge and it take long time to vlookup calculate so try to give any logical function. Thanks in advance Girish On Mon, Oct 18, 2010 at 9:18 PM, krishna mummina <lovemekris...@gmail.com>wrote: > Dear Girish, > > Sorry I didn't understand what you are looking for, > > Please give an Example, what you want exactly? > > May be i have some communication problem to understand your query. > > Thanks, > Excelkid > > On Mon, Oct 18, 2010 at 7:52 PM, girish kumar <girishkumar832...@gmail.com > > wrote: > >> Dear Experts, >> >> need one urgent help from you guys i have attached one file having 2 >> sheets named "system data" & "Raw CDR" >> >> i need a formula for getting name in sheet Raw CDR >> >> for exam >> >> sheet system data having no >> >> 93 Afghanistan Other >> >> and Raw Cdr having No >> >> 93854512115 >> for getting destination name in sheet raw CDR i m using 1st left function >> >> like =left(A2,13) and again giving vllokup formula as mentioned in sheet >> if data not found, then i decrease the no's in left function as 12, 11, 10 >> till i get the destintaion name >> >> problem is data will be very huge and take more time to calculate >> >> so friends if u can find any logical function for this it'll help me very >> much >> >> thanks in advance >> >> Girish >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
help Required.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
