| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Value a cell based on vlookup results
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup based on results from autofilter | Excel Worksheet Functions | |||
| Jump to cell based on cell results created by calendar control too | Excel Discussion (Misc queries) | |||
| Making a Cell turn color based on results in another cell | Excel Discussion (Misc queries) | |||
| =If() results based on cell color? | Excel Worksheet Functions | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
Threaded Mode
