+ Reply to Thread
Results 1 to 2 of 2

Set desired record by using search function - maybe indirect or lookup

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    5

    Lightbulb Set desired record by using search function - maybe indirect or lookup

    Hi guys,

    Thanks for taking time out to read my query.

    I found a great idea online for automating letter writing via excel. I am currently adapting it for my needs but I am a bit stuck.

    http://spreadsheetpage.com/index.php..._without_word/

    (There is also a supporting file on that page)

    You will notice that the indirect function is used to pull the correct info from a data sheet to fill out the blanks in the letter. This is changed by telling it which row you would like to use ( type record 1 or 2 etc and the information within the letter changes).

    Rather than flick through every record or switch between the sheets to check, I would really like to be able to type in part of a reference number which it will recognise from the data sheet and then pull the information from the data sheet and enter into the letter.


    So, if I search reference "4567" on the letter page, the information on the row that "4567" sits (within the data sheet), will be set as the current record and entered into the letter. Of course this will bring up a new set of issues such as what if two lines contain reference "4567" or if searching by name, what if multiple rows contain the same name.

    About myself:
    I have done some excel training but I am not well versed on all excel functions and generally have to research whatever it is I want to do or how to piece together formula or VBA code. So I would be hugely grateful if you can help me on this learning process.

    Thanks again

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Set desired record by using search function - maybe indirect or lookup

    I'm not sure excel can do that but if you post a workbook with what you got then maybe another solution can be found.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ 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. [SOLVED] Typical Lookup function for getting desired result
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2013, 08:32 AM
  2. [SOLVED] Typical Lookup function for getting desired result
    By paradise2sr in forum Excel General
    Replies: 3
    Last Post: 10-06-2013, 08:32 AM
  3. Replies: 0
    Last Post: 10-03-2013, 02:02 AM
  4. Create new record via msgBox option if Search function return NULL/zero value
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2013, 07:19 AM
  5. [SOLVED] LOOKUP function with SEARCH and INDIRECT
    By bubbacheese in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-13-2013, 03:55 PM

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