Vlookup formulas added to excel spreadsheet

Estado: Closed
Premio: $20
Propuestas recibidas: 15
Ganador: ssaidatta123

Winner

Resumen del concurso

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

Habilidades recomendadas

Winner

Publica un concurso similar

Principales propuestas de este concurso

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

Ver más participaciones

Tablero de aclaración pública

aouniradhouene
- 4 años atrás
You said the first entry wins, ... nice :)
- 4 años atrás
Ver 1 mensaje mas
1. aouniradhouene
  - 4 años atrás
  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 años atrás
2. Farrukh Saeed
  - 4 años atrás
  hmm. best of luck next time. as the winner has been chosen can you explain me this formula
  - 4 años atrás
Farrukh Saeed
- 4 años atrás
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 años atrás
ssaidatta123
- 4 años atrás
Hi, I have completed the task. Contact me for file.
- 4 años atrás
musmansur
- 4 años atrás
Hello, I have complete the task. Contact me for the file.
- 4 años atrás
aouniradhouene
- 4 años atrás
Hi, I got your formula working. Contact me I will send you the File.
- 4 años atrás