pricing

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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 =...
  14. 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...
  15. 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...
  16. 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...
  17. W

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

    Hi all I've been using this guide http://web.pdx.edu/~gerbing/325/Resources/Access.pdf which gives reasonable instructions to setup a simple invoicing database, which I've done. https://drive.google.com/open?id=1hLO41QMUGE6vL-76qIQyT_d6ycZ8bVeo If i update the the product table with new...
  18. 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...
  19. 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"...
  20. Roar

    Complex Pricing Formila

    at least for me, probably not for most of you. Pricing of widgets will be volume based 1-24 $5 24-50 - $10 51-100 - $150 But not only that it will be based on term of commitment so one year pricing would be 1-24 if 1 year = $25 1-24 if 2 year = $10 1-24 if 3 year = $5 Can you give me some...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top