+ Reply to Thread
Results 1 to 3 of 3

If function and lookup

  1. #1
    Forum Contributor
    Join Date
    10-15-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    218

    If function and lookup

    Hello All,

    See attached spreadsheet.

    I have two sheets, "workersheet1" and "data". The "worksheet1" is speeding infractions and "Data" sheet is when projects and people had vehicles signed out. I would like to cross-reference the two together.

    What I would like on "worksheet1" is the formula to populate columns J.

    On the "Worksheet1" If the Vehicle Unit #(column B) and date (column H) matches the "Data" sheet Vehicle Unit #(column J) and date is greater or equal to start date (column E) and less than or equal to end date (column F) that it "Worksheet1" project number (column J) returns me the value of "data" sheet (column C)

    I think this would be a vlookup task, but not picky if there are "if" forumlas that would work.

    Any help is greatly appreciated.

    Thank you,
    Attached Files Attached Files
    Last edited by JasonNeedsHelp; 10-22-2020 at 05:37 AM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: If function and lookup

    Try in J2:
    Please Login or Register  to view this content.
    Copy to K2, replace Data!$C$4:$C$325 with Data!$G$4:$G$325

    Drag all down
    Attached Files Attached Files
    Quang PT

  3. #3
    Forum Contributor
    Join Date
    10-15-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    218

    Re: If function and lookup

    Quote Originally Posted by bebo021999 View Post
    Try in J2:
    Please Login or Register  to view this content.
    Copy to K2, replace Data!$C$4:$C$325 with Data!$G$4:$G$325

    Drag all down
    Works perfectly. Thank you!

+ 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] A lookup function to return a persons function which will vary depending on dates
    By lloydalikes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-25-2020, 08:31 AM
  2. Function Help - LOOKUP (Site) & LOOKUP (Person within Values)
    By fwesley in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2019, 01:05 PM
  3. [SOLVED] Lookup / Indirect function to lookup information from various tabs/worksheets
    By rajeshpansara in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-20-2019, 10:29 PM
  4. [SOLVED] Nest lookup Function to lookup name between date range and return value
    By bbeards in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2018, 01:37 PM
  5. lookup based on cellvalue... without the lookup function needed
    By NoSleepForMe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-16-2016, 04:54 AM
  6. Create a lookup formula with an If or Lookup function
    By afountas21 in forum Excel General
    Replies: 2
    Last Post: 09-05-2012, 06:53 PM
  7. [SOLVED] Pivot table doing a lookup without using the lookup function?
    By NGASGELI in forum Excel General
    Replies: 0
    Last Post: 08-02-2005, 01:05 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