wsnyder
Board Regular
- Joined
- Sep 23, 2018
- Messages
- 223
- Office Version
- 365
- Platform
- Windows
Hi All,
Using Microsoft365,
I have an error I dont understand
In the formula, the account I am searching does not exist on the first sheet, so the lookup should be on the second sheet, but the formula is returning #N/A
I definitely see the account on the second sheet so I don't understand the problem.
Thanks
-w
Using Microsoft365,
I have an error I dont understand
In the formula, the account I am searching does not exist on the first sheet, so the lookup should be on the second sheet, but the formula is returning #N/A
I definitely see the account on the second sheet so I don't understand the problem.
Thanks
-w
Excel Formula:
=IF(OR(
ISERROR(VLOOKUP(P13,SalesOps!$B$2:$O$5166,14,FALSE)),
VLOOKUP(P13,SalesOps!$B$2:$O$5166,14,FALSE)="Research"
),
VLOOKUP(P13,ACE_Signup!$A$2:$C$396232,3,FALSE),
VLOOKUP(P13,SalesOps!$B$2:$O$5166,14,FALSE)
)