I have 3 worksheets, 2 are price lists, I want to create the 3rd sheet to look up the part code from one pricelist and show its price and the corresponding part code and price from the other sheet. Neither lists are (or can be) in the same order or sorted as they have to remain in product groups. What Excel function do I use? *Lookup doesn't do it as everything is unsorted! Help!! please!
2006-10-31 07:46:12 · 2 answers · asked by P Durham 3 in Computers & Internet ➔ Programming & Design
3 sheets like sheet1 (price list #1), sheet2 (price list #2) and sheet3 where you want to compare price list 1 and price list 2 for any given code.
in my example column A = part code and Column B = Price for sheets 1 and 2,
in sheet3, column A = part code, column B = price list 1 and column C = price list 2
in cell A2 (sheet3) enter a part code,
in cell B2 enter this formula
=INDEX(Sheet1!$B:$B , MATCH($A2,Sheet1!$A:$A,0) )
in cell C2 enter this formula
=INDEX(Sheet2!$B:$B , MATCH($A2,Sheet2!$A:$A,0) )
2006-10-31 08:05:15 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Hi .. i done something like that .. it will need some coding .. i dont think there is a ready made function for that ..
so .. If u can just send me the excel file u got .. with what sort of output u need in sheet 3 .. i think i can work it for yaa ..
will be waiting for yaa
2006-10-31 08:09:22 · answer #2 · answered by KickBoxer 3 · 0⤊ 1⤋