• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Need help with how to properly visualize a forecast/actuals

    Luke, Thanks for the reply - I'm impressed. I'll have to look at how you put together the graph I like the way you layered it.
  2. M

    Need help with how to properly visualize a forecast/actuals

    All, I need some assistance in how to best visualize four values over the course of a year. 1 - Forecast Target - is the target monthly forecast set by corporate 2 - Forecast is the division forecast 3 - ON PO are is the amount of sales actually on Purchase Order 4 - Actual is the actual...
  3. M

    Need help with ideas for a two charts

    I'm struggling with how to best show slippage from the original due date on a PO to the new date. I want to show the original date in black and then the new revised date in red. I need to visually show late deliveries for several vendors. individual charts are fine for each vendor. The gannt...
  4. M

    bank Dashboard

    I while back I saw a bank dashboard that was static and printed a large piece of paper vs being interactive. It was well laid and and very comprehensive. It might have been included in one of the dashboard contests. But I tried searching and didn't find it. Does anyone remember it?
  5. M

    Data Import

    Can someone recommend a tool they use(e.g. macro, vba script, 3rd party tool) to clean and import excel spreadsheets? I download spreadsheets from mainframes to update my reporting tool each day. Invariably, I have to clean the data of erroneous characters and convert text to numbers. Anyone...
  6. M

    Using vlookup() to find a value using vlookup() on a 2nd table

    Answer: wrong data type. Now everything works fine.
  7. M

    Using vlookup() to find a value using vlookup() on a 2nd table

    Yes - the first vlookup works correctly. It's the second v(lookup) that does not. =VLOOKUP(AF3,Buyers!$A$2:$B$120,2,FALSE) The value in AF3 is the result of a vlookup formula below: =VLOOKUP(L3,PRALL,8,FALSE) Well L3 hand inputed PR# and returns the buyer # in AF3. This lookup works fine.
  8. M

    Using vlookup() to find a value using vlookup() on a 2nd table

    fred, I cannot post the actual workbook - proprietary and all that stuff. If the last post didn't help then I will create a workbook that has the three worksheets, data and formulas.
  9. M

    Using vlookup() to find a value using vlookup() on a 2nd table

    Yes, But remember that the first vlookup gets the buyer number and the second vlookup gets the name associated with that buyer number.
  10. M

    Using vlookup() to find a value using vlookup() on a 2nd table

    I just read re may post and probbaly made it sound different than the reality of the situation. I have one workbook - with three spreadsheets and eash sheet has been renamed. One is called 'Tables Another tab is called 'PR' and it contains a list of data exported from another system and...
  11. M

    Using vlookup() to find a value using vlookup() on a 2nd table

    Hi, I am not sure if this is the right solution the vlookup() calling a second one to get a value. The main reason I am not sure is simply because it isn't working. Here's is what I am trying to do. In worksheet A - I Have a value 12345 in a call A1 that is the result of a vlookup in...
Back
Top