if formula with vlookup

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.
route217Asked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
Do you mean?

=IF(A1="",IF(VLOOKUP(Sheet2!B2,Sheet2!$C$2:$Q$500,14,0)="",VLOOKUP(Sheet2!B2,Sheet2!$C$2:$Q$500,10,0),VLOOKUP(Sheet2!B2,Sheet2!$C$2:$Q$500,14,0)),"")
0
 
Anne TroyEast Coast ManagerCommented:
Where is the value that is being looked up?

=if(isblank(a1),vlookup(...,16,false),if(isblank(vlookup(...,16,false)),vlookup(...,12,false)))
0
 
route217Author Commented:
Value is in sheet 2 column b row 2

Data range c2:q500
0
 
route217Author Commented:
Hi dreamboat

any developments. ..in the if lookup formula?

Regarda
0
 
route217Author Commented:
Nbvc

looks good let me test the formula.
0
All Courses

From novice to tech pro — start learning today.