• 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. S

    Need to return values across 4 columns based on employee cost centre number

    Thanks Sir. I have managed to make a success of the sheet I was working on. Appreciate your assistance.
  2. S

    Need to return values across 4 columns based on employee cost centre number

    still digesting that one. whole file is commercially sensative, no wanna post it in public sorry
  3. S

    Need to return values across 4 columns based on employee cost centre number

    yes, all changed as your post I am correct in assuming; all data being read is the range I want and the last piece is checking the helper column?
  4. S

    Need to return values across 4 columns based on employee cost centre number

    OK, seems to be not liking my data range - in my spreadsheet Hoja1!$A$2:$H$8 is replaced by Data!$Q$2:$x$769 (which is the range I am looking at but it keeps highlighting the $Y$769 when I check it.
  5. S

    Need to return values across 4 columns based on employee cost centre number

    Help! Anyone? Even if I try writing the formula manually it doesn't work. ctrl-shift-enter does zip all if I try to copy the formula off the sheet or the website
  6. S

    Need to return values across 4 columns based on employee cost centre number

    Hi JB That is exactly what I need and WAAAAAAYYY over my abilities. Just one more dumass question; CtrlShift-Enter? Is there a trick? I hold ctrl&shift then press enter. Nothing doing. We are using office 10 if that matters
  7. S

    Need to return values across 4 columns based on employee cost centre number

    Hi SirJB7 Good to see the forum police are out and about; every forum needs one. The standard reply could be warmer dude :) I did actually try searching for what I needed, and your two suggstions are included. The first one links to a Microsoft result that has faulty formulas. Second one is...
  8. S

    Need to return values across 4 columns based on employee cost centre number

    I need to report all employee's in a cost centre, and list them with some data: Cost centre 100 Joe bloggs sales Sydney Fred Dagg admin Melbourne Croc Dundee Animals Darwin So the idea is in one cell we enter the cost centre number in to cell ~A1, then a VLookup function returns all folks...
Back
Top