How to avoid the lookup of Empty Cells

[Mchael]

Hello,

I have a 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

 

[oldbrewer]

in B1 you want to look up A1 in mytable

=if(A1="","",vlookup(A1, mytable,2)

not sure what you mean by "don't want any blank cells in my new table"