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
help Required.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
