1. H

    Getting Specific Rates for Certain Cell Conditions (Logistics)

    Hello All, Firstly, I'm glad to be a member on this community and excited to have my first post. Here's my query: So I wanted column F to auto populate the CWT rate for our shipments. This column F would at least show how much cwt the carrier "column E" would charge us for that weight...
  2. C

    Vlookup Indirect and Match function error

    Hi all, I would like the formula to find the pricing across multiple tabs and the problem is the pricing column. The pricing column is situated on a different column letter on each tab. Would it be possible to replace the 1 from the formula to a match function? like the formula below...
  3. L

    Quote Creation Document - Requiring double lookup

    Hi Would anyone be able to help me? I am trying to create a document that will auto populate from an excel sheet with product and pricing, sheet 1 is the quote template, with sheet 2 being the data behind. Sheet 1 - Quote template <tbody> D EFGH I J K 12 Product Desc Qty Unit Price total...
  4. T

    VLOOKUP - Questions

    Hey guys, I'm currently trying to create a "cheat sheet" for some Pricing. Currently, "Sheet1" looks like this. I have each column represented for the Size/Style/Price/Date. <tbody> Size Style Price Date 24 x 42 Harvey 2 42.88 4-12-19 30 x 42 Harvey 2 45.05 4-12-19 42 x 42 Harvey 2 52.58...
  5. B

    Auto Fill cell with information from Table

    Hey, I'm working on a job cost form to price things for my business. On the job cost form I have it set up as follows: <tbody> Size Shape Color Qty Unit Cost 5" Round Red 5 $0.07 11" Round Red 10 $0.15 </tbody> I also have a sheet that has the pricing data from my main supplier. it...
  6. M

    Formula to input product pricing based on multiple factors

    Man I hope I explain this correctly... I use Excel for a purchase order log. Most materials have a set cost & I have a tab in my log with all materials and use VLOOKUP to input the cost of per line item entry based on the item ordered. However, I have 2 products whose prices vary depending on...
  7. D

    Aggregate Function's Array Argument Gives VOLATILE formula result when using concatenation for Named Range

    Need experts help on this after racking brain over and over. I have a data sheet, 'DATA', that contains Product and Pricing detail by row. Each row will have a column for Product Name (ie. Product A, Product B, Product C....etc), and a column for Location, (ie.Location 1, Location 2, Location...
  8. F

    Formula needed for volume discount pricing

    Hi everyone, I own a printing business and there are a TON of variables in print pricing lol. So I need a formula for multi-page booklets (like catalogs) Basically I will put a formula in that will come up with the number of prints it will take to make a multi-page booklet and I need the...
  9. E

    Pricing comparison

    hey; i need your help; i have a sheet containing 500 types of equipment each equipment has 2 or three prices and i need to get from it the min price , average and max prices and returning the supplier name for each value
  10. D

    Send Email and Log Date Sent

    Experts, I am working on a way to use excel to send out an order form on worksheet "Printer Pricing" and am using a drop down list from a second worksheet named "Master Data". The drop down on "Printer Pricing" populates ship to address and other contact information using vlookup referencing...
  11. J

    need help updating new prices

    I'm trying to pull pricing from a separate workbook. Not all part numbers are included in the new pricing, just the updated ones. Closest I've gotten is the formula below but I don't want a blank when false, I want the old but still current price to remain...
  12. Q

    Incorrect value picked up in Vlookup across multiple columns in one formula

    Hi All, I was trying to vlookup my data from a table with 4 columns, when I applied the following formula there were errors in a few of the calculations. IFERROR(VLOOKUP(LEFT(A4007,3),'USPS - Zone & Pricing Chart'!$B$4:$I$34,2,1),IFERROR(VLOOKUP(LEFT(A4007,3),'USPS - Zone & Pricing...
  13. R

    Clear Contents In VB

    Hello all! New to VB and have a question. I'm trying clear contents in one cell once a drop down is selected. I select a drop down that displays pricing in the the "System Pump" and "VFD Pricing " Cells. What I'd like it to do is clear just the contents in (VFD Pricing $) once "NO" is...
  14. P

    Progressive Pricing Formula

    Hope you can help!! I have a progressive pricing formula I need help with, been tearing my hair out Each band gets individual earnings in steps apart from <10 that gets nothing. In the below example customer sells 35 baskets, so will reach the 4th band. Band 1 - Zero Band 2 - 10 * £1.15 =...
  15. H

    Formula Question in Macro

    my end goal is thatevery month you run the macro and get : "**this month** pricing" and"**next month** pricing" I get an #Name error when I run this. =MONTHNAME()&" Price" Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("U1").Select...
  16. R

    Help with a formula

    Could anybody help me out with a formula to work out some tiered pricing. Assume that I have my pricing structure in cells A1:A5 as follows; A1=£250, A2=£200, A3=£150, A4=£100, A5=£50. In cells B1:B5 I have the volume at which that price kicks in; B1=<50, B2=50-80, B3=80-100, B4=100-120...
  17. N

    Weighted Average with Two Weighting Criteria

    Thanks for your help in advance... I have to figure out pricing, using a weighted average. But I have two Weighting Criteria. Dates & Distance (Fractions of a Mile). <colgroup><col><col><col></colgroup><tbody> Date of Sale Distance Pricing 11/6/2017 0.12 654.36 7/11/2018 0.21 765.31...
  18. W

    how to updating product tables with new yearly pricing - MS 2013

    Hi all I've been using this guide which gives reasonable instructions to setup a simple invoicing database, which I've done. If i update the the product table with new...
  19. B

    Rerouting links between two worksheets in a workbook. Excel 2010

    I'm updating a workbook someone else created a couple years ago and there are two incidences of worksheets that are identical except that Sheet 1 has the Item, Description and pricing info and Sheet 2 has Item and Description but links back to the first one for pricing info. The main sheet...
  20. L

    Vlookup in dynamic workbooks

    Hi I am trying to get a Vlookup funktion to work in a pricing worksheet. The sheet is going to be a template, so the customer account number will change with every use. For each item, i need to lookup a discount value in a pricing file.. The file is named as the account no, ex. "3720.xlsm"...

Some videos you may like

This Week's Hot Topics