That works great! i forgot to also take into consideration when we have
multiple files for the same account our file numbers add an A or a B to
the end of the file number. for example

VEN-00111223A
VEN-00111223B

I am receiving the dreaded #VALUE! on these fields.