2 Lists - Compare Supplier, open Orders and Payment terms

**Nooby0815** · 04-26-2016, 03:38 AM

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

**BadlySpelledBuoy** · 04-26-2016, 03:46 AM

Included in the attached are two methods of accomplishing this.

In the yellow cells I've used VLOOKUP
In the green cells I've used INDEX/MATCH

Hope that helps.

BSB

**Nooby0815** · 04-26-2016, 04:11 AM

Thank you very much BSB for your quick response. Both work for the first row but all others show me #N/A

Is it a problem if the information is in two different Worksheets? I used the $ symbol as in your list.

**BadlySpelledBuoy** · 04-26-2016, 04:18 AM

Have a look at the attached with the tables in different worksheets.
Check if your formulas are anywhere near this in construct.

If you still cannot get it to work, post your formula and perhaps we can spot where it's going wrong from there.

BSB

**Nooby0815** · 04-26-2016, 05:26 AM

Thank you very much BSB for your help.

Everything works charmingly!!

Great

**BadlySpelledBuoy** · 04-26-2016, 05:31 AM

Happy to help.
Have a good day, Leo.

BSB

2 Lists - Compare Supplier, open Orders and Payment terms

LinkBack

Thread Tools

Rate This Thread

Display

2 Lists - Compare Supplier, open Orders and Payment terms

Re: 2 Lists - Compare Supplier, open Orders and Payment terms

Re: 2 Lists - Compare Supplier, open Orders and Payment terms

Re: 2 Lists - Compare Supplier, open Orders and Payment terms

Re: 2 Lists - Compare Supplier, open Orders and Payment terms

Re: 2 Lists - Compare Supplier, open Orders and Payment terms

Thread Information

Users Browsing this Thread

Similar Threads

How to calculate average payment terms

Calculating a due date based on a range of payment terms???

autogenrate due date & no of days than choose payment terms drop down menu

Formula for calculating quarterly, monthly or twice a year payment from supplier

supplier payment term-formula

[SOLVED] Calculating Payment Terms

Supplier Payment Schedule Calculation

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions