Results 1 to 3 of 3

Thread: Excel VLOOKUP for blank cells

Threaded View

  1. Aug 10th, 2005, 09:40 PM #1
    WorkHorse
    WorkHorse is offline

    Thread Starter
    Fanatic Member WorkHorse's Avatar
    Join Date
    Jul 2002
    Location
    Where you live.
    Posts
    591

    Excel VLOOKUP for blank cells

    IS it possible to do an Excel function to do a VLOOKUP for the next blank cell, or do I have to code my own function. I have a situation like where column A is Owner and Column D is Value. I need a cell to return the Value of the first item not owned (that is, the value of column D, for the first blank cell in column A). I tried using a blank cell and "" as the Lookup_value parameter in the VLOOKUP funtion, but it always returns "#N/A". It seems like an Excel funtion should be able to do this without me coding something myself. Any ideas?

    /I meant to post this in the VBA forum. Is there a way for me to move it?
    Last edited by WorkHorse; Aug 10th, 2005 at 09:45 PM. Reason: Should be in VBA forum.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width