I'm working on a IF statement that does the follow checks:
1) Check to see if value exists on VDA Report- If FALSE then move onto 2
- If TRUE then display "Yes" as a result
2) Check to see if the first letter of the adjacent value in column H is "V"- If TRUE then display "Yes" as a result
- If FALSE then go onto 3
3) Display blank result
But whenever it does not find a value at 1), instead of proceeding on to do the check at 2) it jumps all the way to 3). Any reason for this happening? Code below:
=IFERROR(
IF(VLOOKUP(CONCATENATE("EMEA\",H:H),'VDA Report'!A:B,1,FALSE)<>"","Yes",
IF(LEFT(H:H,1)="V","Yes",""))
,"")
Bookmarks