+ Reply to Thread
Results 1 to 4 of 4

Vlookup with if function

  1. #1
    Registered User
    Join Date
    02-16-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Thumbs up Vlookup with if function

    Vlookup fills in the Current Manager Name corresponding with the Current Manager. Now I am trying to get the file to fill in the Co-Manager column D. I want to do a vlookup using the store number in column A again, but need it to only return the name in Column B if the business title showing in column C contains Co-Manager?

    A B C
    Store# Current Manager Business Title
    6005 Felisia Horton Store Manager
    6056 Earlesha Mczeal Store Manager
    6087 Diego Hernandez Store Manager (Nonexempt)
    6090 Erica Martillo Store Manager

  2. #2
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Vlookup with if function

    Check "BLUE"... it might get you started.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-10-2014
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    18

    Re: Vlookup with if function

    Momiieee

    I copied your table in A5:C9 and replicated the store numbers in A15:A18. The put the following formula in B15:B18.


    =IF(INDEX($C$6:$C$9,MATCH(A16,$A$6:$A$9,0))="Co-Manager",VLOOKUP(A16,$A$6:$B$9,2,FALSE),"")

    This will return the value in the 2nd column if the title is "Co-Manager", otherwise a return a ""

    Hope it makes sense!

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Vlookup with if function

    This might be something that you can use:
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Replies: 2
    Last Post: 01-15-2014, 11:40 PM
  2. Need help nesting an index/match function within a Vlookup function.
    By Christopher135 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2013, 06:16 PM
  3. Worksheet function Vlookup and VLOOKUP return different results
    By zandero in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2010, 08:24 AM
  4. Replies: 1
    Last Post: 12-02-2005, 09:35 AM
  5. vlookup function-Can vlookup command find the data from the 5 sheets.
    By Rishab shah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11: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