N
nikko
Hi
Need some help here..
Trying to have the formula to lookup J2 field in the Opp Summary spreadsheet
and return Col I value. If Col I value is blank, then return the value in Col
J.
If Col J value = direct, then show "-"
encountered #Name error for below formula ... any help / advice
appreciated. thanks!
IF(ISBLANK(VLOOKUP($J$2,'Opp Summary'!$A$1:$N$9996,10,FALSE)),
VLOOKUP($J$2,'Opp Summary'!$A$1:$N$9996,9,FALSE), IF(VLOOKUP($J$2,'Opp
Summary'!$A$1:$N$9996,9,FALSE)="Direct", "-", VLOOKUP($J$2,'Opp
Summary'!$A$1:$N$9996,9,FALSE)))
Need some help here..
Trying to have the formula to lookup J2 field in the Opp Summary spreadsheet
and return Col I value. If Col I value is blank, then return the value in Col
J.
If Col J value = direct, then show "-"
encountered #Name error for below formula ... any help / advice
appreciated. thanks!
IF(ISBLANK(VLOOKUP($J$2,'Opp Summary'!$A$1:$N$9996,10,FALSE)),
VLOOKUP($J$2,'Opp Summary'!$A$1:$N$9996,9,FALSE), IF(VLOOKUP($J$2,'Opp
Summary'!$A$1:$N$9996,9,FALSE)="Direct", "-", VLOOKUP($J$2,'Opp
Summary'!$A$1:$N$9996,9,FALSE)))