+ Reply to Thread
Results 1 to 4 of 4

Vlookup needed?

  1. #1
    Registered User
    Join Date
    06-14-2014
    Posts
    3

    Vlookup needed?

    Hello - I am new to this forum, and I am hoping to receive help.
    I have created a spreadsheet that contains (2) worksheets - PAYROLL and SECONDARY INSPECTORS. The PAYROLL worksheet contains the columns Inspectors, Property Addresses, Shared With, Date, Inspection Type, and Fees. The SECONDARY INSPECTORS worksheet contains the columns Primary Inspector, Secondary Inspector and Property Address.

    I would like to find the Secondary Inspectors on the PAYROLL worksheet to plug them into the "Shared With" column. Do I use Vlookup?

    Is it possible to email my spreadsheet for review and support (ASAP) and then talk on the phone?

    I appreciate any help.
    Regards,
    Jeanette

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Vlookup needed?

    You can use VLOOKUP. Possible to upload your workbook here..?

  3. #3
    Registered User
    Join Date
    06-14-2014
    Posts
    3

    Re: Vlookup needed?

    Here is my workbook in question.
    Thank you so much!
    Jeanette
    Attached Files Attached Files

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,807

    Re: Vlookup needed?

    Hi Jeanette,

    This is an Index Match problem because the address is needed to lookup the name. See the attached for your answer.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. Urgent help needed: Vlookup within a Vlookup
    By jozz90 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2013, 07:57 AM
  2. 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
  3. Excel 2007 : vlookup help needed
    By baffled1 in forum Excel General
    Replies: 4
    Last Post: 05-11-2011, 06:47 PM
  4. VLOOKUP or IF( needed?
    By Johnnie in forum Excel General
    Replies: 2
    Last Post: 10-10-2009, 09:32 AM
  5. Replies: 5
    Last Post: 07-29-2009, 07:53 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