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>
</tbody>
can any tell me what am i doing wrong.
thanks
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))
Code | Vendor | Bill Cycle | Notes | Bank # | Transit | Acct # | Contact Name | CC Email | |
100001 | Benton | auto pay | |||||||
100002 | Helli | n30 | auto pay | ||||||
100003 | Canada Post | varies | auto pay |
<tbody>
</tbody>
can any tell me what am i doing wrong.
thanks