Spreadsheet Formulas
Excel VBA
Excel Formulas
User-defined Functions
Excel 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-2008
Updated:
04/02/2008 19:33
This page added:
01 April 1996