How to get a value of a cell next to a empty cell

Closed
mike - 15 Apr 2011 à 20:51
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Jul 2011 à 08:22
Hello, all
I have a question how can i create a VBA that will give me the value of a cell in a colum next to a blank cell?
example..below how can i get the return value "hector" by looking up the BLANK.
please advise.



A B C
1 1/3/07 3/3/07 john
2 1/4/07 3/4/07 tom
3 1/5/07 3/5/07 nick
4 1/6/07 3/6/07 tim
5 1/7/07 3/7/07 paul
6 1/8/07 hector








1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
3 Jul 2011 à 08:22
if you know the cell where the blank data is, then you can use offset to get where you want to go