Results 1 to 5 of 5

0s. blanks and NA with VLookup

Threaded View

  1. #1
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    0s. blanks and NA with VLookup

    I've tried about a dozen if statements to make this work and I've given up.

    PHP Code: 
    =IFERROR(VLOOKUP([@SUPKey],'[Inactive Transport  EA Changes  New Price Plans (2).xlsb] over 6 months inactive'!$A:$C,3,FALSE),""
    For the above, If the value is found but the cell is blank, I want blank
    For the above, If the value is found and the cell value is 0, I want 0
    For the above, If the value is found and the cell value is anything else, I want anything else
    If it isn't found I want ""

    The solution I'm sure is ludicrously simple, but my brain is fried. Can someone please put me out of my misery
    Last edited by Kyle123; 03-25-2013 at 09:11 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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