Michael1974
New member
- Joined
- Mar 31, 2015
- Messages
- 49
- Reaction score
- 0
- Points
- 0
Hello,
I have the attached spreadsheet in which I have to create a macro that will be looking up all the cells except the empty ones. Basicaly, I do not want the vlookup function to lookup the empty cells which will provide as a result N/A. In other words, I want to only lookup the cells where we have something written. I don't want any blank Cells in my new table. Can someone help me with this?
Thanks in advance,
Michael
I have the attached spreadsheet in which I have to create a macro that will be looking up all the cells except the empty ones. Basicaly, I do not want the vlookup function to lookup the empty cells which will provide as a result N/A. In other words, I want to only lookup the cells where we have something written. I don't want any blank Cells in my new table. Can someone help me with this?
Thanks in advance,
Michael