<div>
Where is the value that is being looked up? <br />
<br />
=if(isblank(a1),vlookup(..<wbr />.,16,false<wbr />),if(isbla<wbr />nk(vlookup<wbr />(...,16,fa<wbr />lse)),vloo<wbr />kup(...,12<wbr />,false)))
</div>


Where is the value that is being looked up?

=if(isblank(a1),vlookup(...,16,false),if(isblank(vlookup(...,16,false)),vlookup(...,12,false)))

<div>
Value is in sheet 2 column b row 2<br />
<br />
Data range c2:q500
</div>


Value is in sheet 2 column b row 2

Data range c2:q500

<div>
Hi dreamboat<br />
<br />
any developments. ..in the if lookup formula?<br />
<br />
Regarda
</div>


Hi dreamboat

any developments. ..in the if lookup formula?

Regarda

<div>
Nbvc<br />
<br />
looks good let me test the formula.
</div>


Nbvc

looks good let me test the formula.

<div>
<div class="content wysiwyg-content">
Hi Experts excel 2007<br />
<br />
need a if and vlookup formula to cover the following criteria<br />
if a1 is blank and then vlookup sheet 2 column 16 if a1 is blank and sheet 2 column 16 is also blank then vlookup sheet2 column 12.
</div>
</div>


Hi Experts excel 2007

need a if and vlookup formula to cover the following criteria
if a1 is blank and then vlookup sheet 2 column 16 if a1 is blank and sheet 2 column 16 is also blank then vlookup sheet2 column 12.

if formula  with vlookup

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