Hi this is my current IF statement.
Where there isnt a value in the sheet its looking up it leaves the cell in this sheet as 0. Is there away to change it so it is blank???PHP Code:
=IF('\\ukyorw09\HR\IAC New Starter Tracking\IAC\Application\[TestGood5.xls]Master Data'!$K$2:$K$65000="Yes",'\\ukyorw09\HR\IAC New Starter Tracking\IAC\Application\[TestGood5.xls]Master Data'!N3,"")
Thnaks
Bookmarks