Forum Discussion
Solved
Help on Formula
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 dif...
=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.
=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.
OliverScheurich This worked great. I had the formulas right; I just had the order screwed up.