+ Reply to Thread
Results 1 to 2 of 2

VLookup to use multiple search terms to populate a different tab

  1. #1
    Registered User
    Join Date
    08-05-2019
    Location
    England
    MS-Off Ver
    Office 2016
    Posts
    19

    VLookup to use multiple search terms to populate a different tab

    Hi All,

    I am currently working on some data which needs to be popilated into our yearly planner database.

    As shown on the attached, the data tab holds the reference numbers which are needed and the planner tab is were we need to automate this sheet to lookup and return set data from this tab onto the planner.

    As you can see on planner tab, each month has its own column, so for each month from Jan onwards we are required to carry out planned works and I want to be able to program the attached to search the data tab and populate each monthly column based on the search criteria (property name and repair) and to ensure the work listed as 1/1/2020 is added in the column for January.

    Hope someone can urgently help.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,554

    Re: VLookup to use multiple search terms to populate a different tab

    Notice that to accomplish this the column headers in H1, K1 and N1 are changed to dates and custom formatting is applied: "Work Order -"mmmm
    The formula that populates the columns is:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Formula to search specific set of terms in a string and return any found terms
    By fk_ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2020, 10:26 AM
  2. Multiple search terms in same column?
    By getmemickey in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-04-2016, 08:23 PM
  3. Truncate text strings using LEFT and FIND/SEARCH for multiple search terms
    By ngdoherty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2013, 07:51 PM
  4. Search within a cell for multiple defined terms
    By fstone33 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2012, 11:09 AM
  5. multiple search terms (sorry if in wrong subforum)
    By meneses in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-19-2012, 11:21 AM
  6. Search multiple terms through excel
    By rich80 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2007, 03:33 AM
  7. [SOLVED] how to set up a vlookup table with 2 search terms?
    By WendyL in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2005, 09:06 AM

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