Sep 27 2021 11:24 AM
Sep 27 2021 11:42 AM
Let's say you have a list of vendor codes with related information on a sheet named Vendors:
On your payment sheet, you enter the vendor code in for example D2 and down.
In E2, enter the formula
=IFERROR(VLOOKUP(D2,Vendors!$A$2:$Z$100,2,FALSE),"")
In F2, that would be
=IFERROR(VLOOKUP(D2,Vendors!$A$2:$Z$100,3,FALSE),"")
etc.
Adjust the range if necessary - it doesn't matter if it is larger than your actual vendors list.
You can copy/fill the formulas down as far as you want.