Beyondrelational

Profile of Gurusamy at beyondrelational.com

Sunday, March 21, 2010

VLOOKUP() and ISNA() Functions

Use VLOOKUP(), ISNA(), IF() Functions

=IF(ISNA(VLOOKUP(1,Sheet1!C5:E5,3,FALSE)),0,VLOOKUP(1,Sheet1!C5:E5,3,FALSE))

=IF(Sheet1!C5=2,(VLOOKUP(2,Sheet1!C5:E5,3,FALSE)),0)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)