Spreadsheet Formulas
Excel VBA
Excel Formulas
User-defined Functions
Office Links
Access VBA
Access SQL
Alan’s Excel FAQ
Excel Home
Alan’s Home
Perform Calculation if Both Conditions met
=IF(A1=5,IF(B1=10,VLOOKUP(A1,H3:I12,2),"2nd no match"),"1st no match")
© 1996-2011
Updated:
09/11/2011 15:58
This page added:
01 April 1996