index and match - Robuta Search

https://community.smartsheet.com/discussion/91355/how-to-find-the-max-valor-using-index-and-match How to find the Max Valor using INDEX and MATCH? - Smartsheet Community how to find index and match the max https://techcommunity.microsoft.com/discussions/excelgeneral/index-and-match-function-with-or-statement/555459 Index and Match Function With "Or" Statement | Microsoft Community Hub Hi All, I am trying to use the Index function to return a list of values that meet one of multiple criteria.For Example; In the file attached, if I... index and match function statement microsoft community https://community.smartsheet.com/discussion/69178/index-and-match-or-vlookup-or-both Index and Match or VLookup or both - Smartsheet Community I am trying to recreate this excel formula in smartsheet: =IF(ISNA(VLOOKUP(B2,'Participating Hotels'!$B:$B,2,FALSE)),"Not Available","Available") * "B2" is the... index and match vlookup smartsheet community