Hi:

I am writing a macro that searches for a value within a particular cell. If there is nothing in that cell, I would like the macro to skip down to the next row and check that cell. If there is a value in that initial cell, the formula is setup to do a vlookup to pull info from another table. Does anyone know how to manipulate Excel so that the macro checks a cell for a value, and if no value, check the cell immediately below it? I can't quite get it to work.

Thanks for any help you can offer!