Vlookup formulas added to excel spreadsheet

Status: Closed
Nagroda: $20
Uzyskane Zgłoszenia: 15
Zwycięzca: ssaidatta123

Winner

Opis Konkursu

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

https://revamp365.sharepoint.com/:f:/g/ElZCRY1-3ghEkaqcSLar3vMByR269zqk-ZeH1lt9ygkLQA?e=L3e7Q0

Zalecane Umiejętności

Winner

Opublikuj Konkurs Taki Jak Ten

Najlepsze zgłoszenia do tego konkursu

ssaidatta123 India

1
babukanth Canada

0
swapnildhake India

0
marcosschualle Argentina

0
salmanhq381 Pakistan

0
CAAshish1012 India

0
Farrukh Saeed Pakistan

0
umairabdillah12 Indonesia

0
elqueabandona Argentina

0
musmansur Pakistan

0
aouniradhouene Tunisia

0

Zobacz więcej zgłoszeń

Publiczna Tablica Wyjaśnień

aouniradhouene
- 4 lat temu
You said the first entry wins, ... nice :)
- 4 lat temu
Wyświetl 1 wiadomość więcej
1. aouniradhouene
  - 4 lat temu
  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 lat temu
2. Farrukh Saeed
  - 4 lat temu
  hmm. best of luck next time. as the winner has been chosen can you explain me this formula
  - 4 lat temu
Farrukh Saeed
- 4 lat temu
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 lat temu
ssaidatta123
- 4 lat temu
Hi, I have completed the task. Contact me for file.
- 4 lat temu
musmansur
- 4 lat temu
Hello, I have complete the task. Contact me for the file.
- 4 lat temu
aouniradhouene
- 4 lat temu
Hi, I got your formula working. Contact me I will send you the File.
- 4 lat temu