I've tried about a dozen if statements to make this work and I've given up.
For the above, If the value is found but the cell is blank, I want blankPHP Code:
=IFERROR(VLOOKUP([@SUPKey],'[Inactive Transport EA Changes New Price Plans (2).xlsb] over 6 months inactive'!$A:$C,3,FALSE),"")
For the above, If the value is found and the cell value is 0, I want 0
For the above, If the value is found and the cell value is anything else, I want anything else
If it isn't found I want ""
The solution I'm sure is ludicrously simple, but my brain is fried. Can someone please put me out of my misery
Bookmarks