+ Reply to Thread
Results 1 to 3 of 3

Help Please - New User

  1. #1
    Registered User
    Join Date
    12-05-2015
    Location
    Newcastle England
    MS-Off Ver
    office 2007
    Posts
    2

    Cool Help Please - New User

    Hi.
    I have a spread sheet which I use at work. It contains up to 1300 lines of information, not always listed in alphabetical order.

    I am looking for a formula which will search the spread sheet for a specific piece of information using multiple criteria such as:

    Branch name Customer Type Month and then the actual figure

    and then return the number to another TAB on the same spread sheet. The main data sheet will not always be the same size so I cant simply copy the cell to my summary page. I need the formula to search using multiple criteria. I have tried V and H lookup with no joy and I am now being drive mad by this, please help if you can.

    Kind Regards
    Paul

    Ps Tried uploading an example file but for some reason I cant add it?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: Help Please - New User

    There is really not enough information there. Try again to upload a sheet. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    The paperclip icon

    HOWEVER< you also need to amend the title of your thread. Many users search for possible solutions to their problems. Your title is so vague, it could mean anything. To change a title, go to "thread tools" at your first post in this thread. It's in there...
    Glenn



  3. #3
    Registered User
    Join Date
    12-05-2015
    Location
    Newcastle England
    MS-Off Ver
    office 2007
    Posts
    2

    Re: Help Please - New User

    Thank you.
    Tried uploading the file but just get a timer going round and round. Tried saving in a different format but no luck. Any suggestions please?
    Paul

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-27-2015, 01:31 PM
  2. Replies: 2
    Last Post: 03-10-2013, 09:56 PM
  3. user defined macro to replace certain characters in a string based on user input
    By whatappears in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2012, 06:25 PM
  4. Replies: 0
    Last Post: 12-14-2011, 02:28 PM
  5. Insert user's name into cell based on windows user login when a button is clicked.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-16-2011, 01:08 PM
  6. Match new password to specific user and update list via custom user form
    By Sargekd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2011, 09:40 AM
  7. Pause macro for user input then search for user's answer across multiple sheets
    By sassy2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-04-2009, 03:55 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1