Hi experts excel 2010
How would you write a formula so if in column A cell 2 you have a data value and cell A3 is empty then in A3 then lookup applies but ignore all cells in column a where you already have a value..
Col A. Col B.
Wcd. Lookup return nothing
Here blank look finds value from look up table
Adds. lookup returns nothing