Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Help with Excel look ups!?
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!
2 Answers
- Anonymous1 decade agoFavorite Answer
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) )
- 1 decade ago
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