Hi Guys,
I have 2 lists and I need to bring them together. (They are in one spreadsheet)
List 1:
A
Vendor Number
B
Vendor Name
C
Purchase Order Number
List 2:
A
Vendor Number
B
Payment terms
Now I want that Excel compares the Vendor Numbers from list 1 and 2 and if they match then Excel should transfer the Payment terms from List 2B to my List 1...new column D so I have all information in one list.
Does anyone knows the right Formular? I am not very familiar with excel and especially not in English
Any help would be more than appreciated.
Warm Regards
Leo
Bookmarks