Help on Formula

Question

I have an Excel Workbook with two sheets

Sheet one contains a subset of vendors from Sheet two. Sheet one contains 50 Vendors and Sheet two contains 3000 Vendors

Sheet one and Sheet two have different information about these vendors

Sheet one column B has contains the vendor number.

Sheet two column A contains the vendor number

If the vendor is on sheet one, I want to copy the information in column M of the matching vendor in sheet two to column T in sheet 1

How can I accomplish that using excel formulas?

oliverscheurich · Accepted Answer

MJSMichael611&nbsp;=INDEX('sheet two'!$M$2:$M$30000,MATCH('sheet one'!B2,'sheet two'!$A$2:$A$30000,0))You can try INDEX and MATCH. An alternative could be VLOOKUP.&nbsp;

Forum Discussion

Help on Formula

Share

Resources