LinkBack URL
About LinkBacks
however it is better to only conduct the MATCH element rather than repeat the entire VLOOKUP, eg:
=IF(ISNA(MATCH(lookup_value,lookup_array,0)),0,VLOOKUP(criteria,table_array,col_index_num,range_lookup))
however it is better to only conduct the MATCH element rather than repeat the entire VLOOKUP, eg:
=IF(ISNA(MATCH(lookup_value,lookup_array,0)),0,VLOOKUP(criteria,table_array,col_index_num,range_lookup))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks