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)))
--
nikko