Results 1 to 3 of 3

Dual VLookup Formula

Threaded View

  1. 08-29-2015, 05:18 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Dual VLookup Formula

    Hello:

    Please refer to attached file.
    Sheet1 from Column AM thru AV has clockIn-Clockout info and Column AW has total hours worked
    for a single day.

    Sheet2: Name of Employee is in Cell K7
    I need formula in cell K12:S18 to bring ClockIn-ClokOut data from Sheet1 for employee in Cell K7 Sheet2.



    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Want to replace NA with 0 but in a dual vlookup
    By MBCMDR in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-14-2015, 10:33 AM
  2. Trying to combine an if statement & a dual vlookup...its doing something but....
    By lhunt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2013, 12:27 PM
  3. [SOLVED] Need help correcting a possible dual VLOOKUP formula
    By pearsonj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2013, 02:01 PM
  4. Help! Dual Vlookup function? Sumproduct with index array?
    By thaprofessor33 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-03-2012, 09:08 AM
  5. Dual Lookup/Vlookup/Match criteria
    By jj72uk in forum Excel General
    Replies: 6
    Last Post: 10-16-2009, 04:03 PM
  6. dual formula in one cell?
    By Ltat42a in forum Excel General
    Replies: 2
    Last Post: 05-13-2009, 12:16 PM
  7. Dual Verical Lookups under one formula
    By perfectview in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-11-2009, 05:49 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1