excel formula help
6 TopicsFind lowest price along with that vendor's name
Hello, On one tab, "BOM BRKDN", I have a materials list with several unique part numbers. On a second tab, "PRICING", is a list of all vendor quotes for all part numbers. I have a "Best Price" column (that seems to work fine) using the formula "=MIN(IF(E2=PRICING!$C$2:$C$10000,PRICING!$A$2:$A$10000))" (fyi; column E is unique part numbers on "BOM BRKDN" tab; column C is part number on "PRICING" TAB, column A is the price quoted on "PRICING" tab. I am trying to find a formula that will reference the best price and the part number to then find and auto-fill the associated vendor name (listed under column B on the "PRICING" tab). I've tried a variety of lookup formulas without success. Can someone please help?!?! Thank youSolved9.8KViews0likes2CommentsExcel Formula
I’ve got an Excel workbook with multiple worksheets, each one having different numbers of rows and columns. Each worksheet has a variable called flag. I’m curious if there is some way for Excel to search the entire workbook for cases where flag=‘Flag’ and then highlight the row containing the value. thanks, Mike866Views0likes1CommentSpecific Excel Formula Help
Hey guys, I'm new here so sorry if this isn't a very tough question but how would i input a formula that would read, Knowing that in 1 case of QTR there are 4 sleeves and each sleeve has 15 units. Product Case Sleeve Unit Total Units QTR1(Pre Day) + 1 3 70 175 QTR2(Post Day) - 0 2 30 60 QTR3(Difference/End Day Total) = 1 3 10 115 I would need this on a scale for about 30 separate Items formatted the Same way as QTR but Independent, So any help with the formula or a Better Idea on how to format it to get the same result would be much appreciated!826Views0likes1CommentNeed help setting up options that correspond with numeric values
Im trying to set up a excel worksheet to use for product orders. In it I want to be able to select certain options that are set to automatically calculate the cost value. for example 1st option if chosen is $240 2nd option if chosen is $120 3rd option if chosen is $60623Views0likes0Comments