+ Reply to Thread
Results 1 to 3 of 3

Return blank if $N/A syntax for multi axis vlookup

  1. #1
    Registered User
    Join Date
    04-29-2020
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    2

    Return blank if $N/A syntax for multi axis vlookup

    Alrighty I have been baffled by this issue. I have tried a couple of things but have not been able to get past the to many arguments error. The currently formula is working as designed accounting for blanks in the lookup table and returning blank cells. However, I am struggling with is adding syntax that removes errors and shows blank specifically if the J6 cell is not populated

    Any help would be much appreciated.

    =IF(VLOOKUP($J$6,'Release Matrix'!$B$7:$AF$15,MATCH(L5,'Release Matrix'!$B$5:$AF$5,0))=0,"",VLOOKUP($J$6,'Release Matrix'!$B$7:$AF$15,MATCH(L5,'Release Matrix'!$B$5:$AF$5,0)))

    Thank you in advance!

    RG

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Return blank if $N/A syntax for multi axis vlookup

    =iferror(IF(VLOOKUP($J$6,'Release Matrix'!$B$7:$AF$15,MATCH(L5,'Release Matrix'!$B$5:$AF$5,0))=0,"",VLOOKUP($J$6,'Release Matrix'!$B$7:$AF$15,MATCH(L5,'Release Matrix'!$B$5:$AF$5,0))),"")
    try above formula
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    04-29-2020
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    2

    Re: Return blank if $N/A syntax for multi axis vlookup

    Works like a dream! Thank you Ravi!

+ 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. vlookup over multiple pages and return multi values
    By juriemagic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2019, 12:13 PM
  2. [SOLVED] If two cells are blank then return blank, else vlookup cell with populated data
    By Jason G in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-06-2017, 10:20 AM
  3. Replies: 3
    Last Post: 04-30-2014, 05:57 AM
  4. [SOLVED] VLOOKUP - If table array is blank, need it to return blank
    By bxk006 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2014, 11:36 AM
  5. [SOLVED] Need formula to return blank instead of #N/A when source cell is blank, using VLOOKUP
    By TMB1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2013, 07:16 PM
  6. Replies: 0
    Last Post: 06-13-2011, 11:11 AM
  7. Excel 2007 : VLookup date range and return multi lines
    By rik1603 in forum Excel General
    Replies: 1
    Last Post: 02-18-2010, 11:04 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