+ Reply to Thread
Results 1 to 10 of 10

vlookup across sheets help needed

  1. #1
    Registered User
    Join Date
    08-23-2018
    Location
    Union City, CA USA
    MS-Off Ver
    office365
    Posts
    54

    vlookup across sheets help needed

    hi all,

    i think this is easy for a pro...

    i have two tabs, a helper tab to pull info from, onto the "report" worksheet.

    on the report sheet, user names are only listed once. then there are four groups of data column, with a date (undr the name header) and a status column.

    i need the vlookup on the report sheet to look at the name in column B, find that name in column B on the helper sheet and if the name column C is not blank, report back the date in column C and teh status in column D.

    can someone please help a newbie?
    Attached Files Attached Files
    Last edited by FlameRetired; 04-29-2021 at 06:49 PM. Reason: Title change by Mod

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: vlookup help needed

    Hi
    Do you use excel 2013?

  3. #3
    Registered User
    Join Date
    08-23-2018
    Location
    Union City, CA USA
    MS-Off Ver
    office365
    Posts
    54

    Re: vlookup help needed

    we use excel 365

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: vlookup help needed

    You might want to update it in your account so others will know how to better help you.

  5. #5
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: vlookup help needed

    For the date try:
    C3 and down, copied to all columns with names:
    =SUMPRODUCT(IF(ISNUMBER((helper!$B$2:$B$17=$B3)*(helper!$A$1:$J$1=C$2)*(helper!$A$2:$J$17)),((helper!$B$2:$B$17=$B3)*(helper!$A$1:$J$1=C$2)*(helper!$A$2:$J$17)),""))

    for the status, D3 and down:
    =INDEX(helper!$A$1:$J$17,SUM((helper!$C$2:$J$17=C3)*(helper!$C$1:$J$1=C$2)*(helper!$B$2:$B$17=$B3)*ROW(helper!$C$2:$J$17)),MATCH(C$2,helper!$A$1:$J$1,0)+1)
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-23-2018
    Location
    Union City, CA USA
    MS-Off Ver
    office365
    Posts
    54

    Re: vlookup help needed

    thanks man, i would have never thought of those formulas, i thought a vlookup would do the trick.

    note that there is an error being reported back on your sheet, any fix for that?

  7. #7
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: vlookup help needed

    Hi,
    I'm not a man : )
    You're welcome.
    Please see with error amended....
    Attached Files Attached Files
    Last edited by Limor_OP; 04-29-2021 at 05:12 PM.

  8. #8
    Registered User
    Join Date
    08-23-2018
    Location
    Union City, CA USA
    MS-Off Ver
    office365
    Posts
    54

    Re: vlookup help needed

    thank you very much! no offense meant! thanks woman!

  9. #9
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: vlookup help needed

    None taken : )

    Vlookup indeed doesnt fit here.
    You might want to change your post title to :
    "Find a date and status match for names repeated multiple times"

  10. #10
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: vlookup help needed

    D8THSTAR

    Administrative Note:

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

    As you are a fairly new member I have changed the title for you this time. The one you used is not very descriptive. Please consider how likely it is someone would use a search string like your title to find this thread.
    Dave

+ 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. IF-THEN with a possible VLOOKUP? help needed
    By CloverBlood in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2015, 10:36 PM
  2. Urgent help needed: Vlookup within a Vlookup
    By jozz90 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2013, 07:57 AM
  3. Complex Vlookup/ VBA function or Macro Needed For "if contains text then vlookup"
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-09-2012, 03:48 AM
  4. Help needed with vlookup
    By adamshort12 in forum Excel General
    Replies: 1
    Last Post: 02-04-2011, 09:09 AM
  5. Replies: 5
    Last Post: 07-29-2009, 07:53 AM
  6. VLOOKUP help needed PLEASE...
    By Levi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-08-2006, 03:45 PM
  7. [SOLVED] vlookup help needed
    By Steven J in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2005, 07:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1