+ Reply to Thread
Results 1 to 2 of 2

Conditional VLook

  1. #1
    Registered User
    Join Date
    06-19-2020
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    1

    Unhappy Conditional VLook

    Hi everyone,

    Currently I am creating an automated data base. I'm seeking for your help and expertise about conditional vlookup, the formula is below. Can you please detect what is the problem in the formula? the result is always at "0" because iferror is added, however the result is blank if iferror is removed.

    =IFERROR(IF(VLOOKUP(D15,'EM Feedbacks'!A3:A58,1,0)='BA_2021 MAR'!D15,IFS('EM Feedbacks'!C3=Validation!$F$3,Validation!$D$3,'EM Feedbacks'!C3=Validation!$F$4,Validation!$D$11,'EM Feedbacks'!C3=Validation!$F$5,Validation!$D$12)," "),0)

    Please help me how to fix this? Thaaanks!

    Note: EM Feedbacks, BA_2021, Validation are sheet names.

    Thank you in advance everyone!~

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Conditional VLook

    It is not possible to tell what the problem is with the formula without knowing:

    1. What you want the formula to do (why is blank the wrong answer?)
    2. What the data is that is being referenced by the formula

    What do you want the data to do?

    What data is in D15, 'BA_2021 MAR'!D15, 'EM Feedbacks'!A3:A58, 'EM Feedbacks'!C3, Validation!$F$3, Validation!$D$3, Validation!$F$4,Validation!$F$5, Validation!$D$12
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] Conditional VLook Up
    By franztupaz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-18-2019, 01:15 PM
  2. [SOLVED] Vlook up with Conditional Formatting
    By msvoboda27 in forum Excel General
    Replies: 6
    Last Post: 09-19-2018, 07:03 AM
  3. [SOLVED] VLOOK Formula Only Shows the VLOOK Formula Instead of Lookup Value
    By onlyonekj in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-29-2017, 03:30 PM
  4. Vlook up /Conditional formatting
    By Su3b3a in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-15-2015, 09:38 AM
  5. Using vlook up
    By mahershams in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-26-2013, 09:28 AM
  6. [SOLVED] Vlook up
    By isasa74 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2013, 05:46 AM
  7. [SOLVED] VLOOK
    By Domenic in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM

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