Dear Girish Please find herewith enclosed file.
regards sumit On Tue, Oct 19, 2010 at 10:32 AM, girish kumar <girishkumar832...@gmail.com>wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
Copy of help Required-1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
