Column A contains numerous cells with a project number (for example
200746498). The number of cells valued can change, right now we have values
in cells A3-A88. I have named the column projects. Right now I have a
vlookup statement in cell D2 which reads "VLOOKUP(C2,projects,1,FALSE)" where
I am inputting a project number in cell C2 and checking if that number is
already entered in the projects column (checking for duplicates). If it is
already there I don't want to do anything with it but if it has not been
entered in the projects column (the formula above returns an NA) I need to
find the first open cell in the column (this could change as projects are
added or deleted) and add the project number to the end of the list.
Thanks for your help.

"Pete_UK" wrote:

Perhaps you could explain exactly what you want to do, and give
details like the sheet names involved, the cells you want to work with
and the formula you are using now.

Pete

On May 21, 7:55 pm, robeck wrote:
Do I need to write something in Visual Basic? I have done some macros but
haven't done anything conditional with a macro, is there a way to do that?



"Pete_UK" wrote:
A formula cannot move or copy a cell, so you would need a macro to do
what you want to achieve.

Pete

On May 21, 4:34 pm, robeck wrote:
I am using vlookup to interrogate a column of cells and if the value I input
is not found in the column I would like to move the input value to the 1st
open cell at the end of the column. I don't know how to determine what the
1st open cell is without having to list each cell and check if it is blank..
Is there a way to look for the first cell that is blank? Thanks.- Hide quoted text -

- Show quoted text -