Hey Trevor,
How could I modify this so to autofill column E with the results. Also If #N/A is the returned value how to I change this to equal "!! N0 B2B Status Found !! in dark blue.

Bob