Hi
i have the table below and this vlookup formula but for the row 3 works fine but one and two doesn't pull the the data is blank.
=IF(ISERROR(VLOOKUP($D$6,Vendors!$A:$J,2,FALSE)),"",VLOOKUP($D$6,Vendors!$A:$J,2,FALSE))
<tbody>
Code
Vendor
Bill Cycle
Notes
Bank #
Transit
Acct #
Contact...