Vlookup formulas added to excel spreadsheet

Genel Açıklama Panosu

• 

  aouniradhouene

  • 4 yıl önce

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

  • 4 yıl önce
  1 mesaj daha görüntüle
  1. 

     aouniradhouene

     • 4 yıl önce

     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 yıl önce
  2. 

     Farrukh Saeed

     • 4 yıl önce

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

     • 4 yıl önce
• 

  Farrukh Saeed

  • 4 yıl önce

  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 yıl önce
• 

  ssaidatta123

  • 4 yıl önce

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

  • 4 yıl önce
• 

  musmansur

  • 4 yıl önce

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

  • 4 yıl önce
• 

  aouniradhouene

  • 4 yıl önce

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

  • 4 yıl önce

Daha fazla yorum göster