Type of vloopkup, or something else?

[akvanden]

I have a massive table (20 or so columns, 12000 rows) with data that has about 95% of the data populated in a column called "description." The problem I have is that I need to populate the other 5% with a description based off a separate key/table that I have. I could easily do a vlookup to populate these values, but the issue I run into is that the other 95% of the descriptions gets deleted because my key/table only has the values for the missing 5%. Is there a way I can tell my vlookup to only search for blanks in the description column or maybe even a way other than a vlookup?

Thanks.

 

[Andrew Poulsom]

Select the blank cells in the description column (Edit|Go To|Special|Blanks), type your lookup formula for the active cell and press Ctrl+Enter to populate them all. You can Copy/Paste Special|Values afterwards if you want.