Pull information from Sheet if Cell is blank

I've attached a little sample. What I need is to get a few data fields if the Voucher number is blank, or is less than 7 characters, unless the value is NA or N/A. I could do this easily with a pivot table, except that this is in a shared workbook, so pivot tables can't be updated without unsharing, and I need current information and don't want to unshare.

So, what I'd like is a series of formulas that can bring in the requisite information. So far my brain is circling but without any hits. Any help would be appreciated.