Vlookup formulas added to excel spreadsheet

Public Clarification Board

• 

  aouniradhouene

  • 4 years ago

  You said the first entry wins, ... nice :)

  • 4 years ago
  View 1 more message
  1. 

     aouniradhouene

     • 4 years ago

     Well Furrukh, Trust me I used VALUE(RIGHT(CELL, LEN(CELL)-1) To clean up the phone number and remove the 1 indicator then INDEX Formula with IFERROR in case the Phone number is Empty :) Anyway, this is not serious, I finished the Job 23 min after he post it :)

     • 4 years ago
  2. 

     Farrukh Saeed

     • 4 years ago

     hmm. best of luck next time. as the winner has been chosen can you explain me this formula

     • 4 years ago
• 

  Farrukh Saeed

  • 4 years ago

  double check for those who generate value with vlookup criteria (true, approximate) it is just generating random values from the database. further, you cannot generate exact value with vlookup until unless you apply some fixes to the sheet

  • 4 years ago
• 

  ssaidatta123

  • 4 years ago

  Hi, I have completed the task. Contact me for file.

  • 4 years ago
• 

  musmansur

  • 4 years ago

  Hello, I have complete the task. Contact me for the file.

  • 4 years ago
• 

  aouniradhouene

  • 4 years ago

  Hi, I got your formula working. Contact me I will send you the File.

  • 4 years ago

Show more comments