<div>
<div class="content wysiwyg-content">
Hi experts excel 2010<br />
<br />
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, so the formula copies the data entry from cell A2 and in cell A3 the lookup applies. Formula in cell b2. Etc...<br />
<br />
So<br />
Col A. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Col B.<br />
Wcd. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Wcd.<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; Adds.<br />
<br />
Etc...
</div>
</div>


Hi experts excel 2010

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, so the formula copies the data entry from cell A2 and in cell A3 the lookup applies. Formula in cell b2. Etc...

So
Col A.          Col B.
Wcd.            Wcd.
                     Here blank look finds value from look up table
Adds.           Adds.

Etc...

Tricky vlookup with if formula

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