<div>
The formula has to apply to both text data and numerical data...
</div>


The formula has to apply to both text data and numerical data...

<div>
The formula would be something along this line (inserted in B2 and copied down):<br />
<b>=IF(A2&lt;&gt;&quot;&quot;,&quot;&quot;,VLOOKUP(<i>lookup_value, table_array, col_index_num, [range_lookup]</i>))</b><br />
<br />
We may need to see a more-detailed example if this isn't helpful.<br />
<br />
Regards,<br />
-Glenn
</div>


The formula would be something along this line (inserted in B2 and copied down):
=IF(A2<>"","",VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]))

We may need to see a more-detailed example if this isn't helpful.

Regards,
-Glenn

<div>
Thanks Glenn excellent feedback.<br />
<br />
If I amend formul to =if (isna (A2 &lt;&gt;&quot;&quot;,&quot;&quot;, vlookup etc...would this work also..
</div>


Thanks Glenn excellent feedback.

If I amend formul to =if (isna (A2 <>"","", vlookup etc...would this work also..

<div>
<div class="content wysiwyg-content">
Hi experts excel 2010<br />
<br />
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..<br />
<br />
So<br />
Col A. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Col B.<br />
Wcd. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Lookup return nothing<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Here blank look finds value from look up table<br />
Adds. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lookup returns nothing<br />
<br />
Etc...
</div>
</div>


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..

So
Col A.          Col B.
Wcd.            Lookup return nothing
                     Here blank look finds value from look up table
Adds.           lookup returns nothing

Etc...

Vlookup  up to find only empty cell in a column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.