Spreadsheet Formulas

User-defined Functions

Alan’s Excel FAQ

Perform Calculation if Both Conditions met

=IF(A1=5,IF(B1=10,VLOOKUP(A1,H3:I12,2),"2nd no match"),"1st no match")

© 1996-2009

Updated:	06/04/2009 22:32
This page added:	01 April 1996