Vlookup formulas added to excel spreadsheet

  • Status: Closed
  • Prize: $20
  • Entries Received: 15
  • Winner: ssaidatta123

Contest Brief

Video explainer attached in sharepoint folder below.

I need to add a formula to the first tab so it pulls data in the 3 additional rows from the database.

First entry that has formula filled out and data added will be awarded

[login to view URL]:f:/g/ElZCRY1-3ghEkaqcSLar3vMByR269zqk-ZeH1lt9ygkLQA?e=L3e7Q0

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

  • aouniradhouene
    aouniradhouene
    • 1 month ago

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

    • 1 month ago
    1. aouniradhouene
      aouniradhouene
      • 1 month 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 :)

      • 1 month ago
    2. imfarrukh47
      imfarrukh47
      • 1 month ago

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

      • 1 month ago
  • imfarrukh47
    imfarrukh47
    • 1 month 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

    • 1 month ago
  • ssaidatta123
    ssaidatta123
    • 1 month ago

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

    • 1 month ago
  • musmansur
    musmansur
    • 1 month ago

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

    • 1 month ago
  • aouniradhouene
    aouniradhouene
    • 1 month ago

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

    • 1 month ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!