+ Reply to Thread
Results 1 to 5 of 5

Need Help with IF and VLOOKUP Function

  1. #1
    Registered User
    Join Date
    11-14-2019
    Location
    Maryland
    MS-Off Ver
    Excel for MAC 16.3
    Posts
    12

    Need Help with IF and VLOOKUP Function

    on the "February 7th, 2020" sheet I have when you select an assignment (c11 for example) it moves forward to another dependent list. I'm having trouble with populating a description when the dependent list is selected. I thought I had it and realized real quick that when i changed other areas of the form it wasn't grabbing descriptions.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Botswana
    MS-Off Ver
    Professional Plus 2019
    Posts
    748

    Re: Need Help with IF and VLOOKUP Function

    I think you're just missing descriptions on the magnets tab, It's returning a "-", as the formula calls for. What am I missing? Try changing all the "-"'s to something that be returned, as a test.

  3. #3
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,247

    Re: Need Help with IF and VLOOKUP Function

    Moved to Mac forum
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  4. #4
    Registered User
    Join Date
    11-14-2019
    Location
    Maryland
    MS-Off Ver
    Excel for MAC 16.3
    Posts
    12

    Re: Need Help with IF and VLOOKUP Function

    did that and for some reason it still shows "-" in some of the areas

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,648

    Re: Need Help with IF and VLOOKUP Function

    Try the following in cell C14:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    You may then select the cell > press Ctrl + c > select the cell to which you wish to copy the formula > press Ctrl + v
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Formula Structure Error When Combining IF Function with VLOOKUP Function
    By EverClever in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2017, 03:11 PM
  2. [SOLVED] VLOOKUP formula or VLOOKUP worksheet.function
    By Crispy85 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-09-2017, 09:40 AM
  3. Replies: 2
    Last Post: 01-15-2014, 11:40 PM
  4. 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
  5. 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
  6. Replies: 1
    Last Post: 12-02-2005, 09:35 AM
  7. 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

Tags for this Thread

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