Thanks, very clearly presented - keep up the good work! Question for you - how would you match to multiple rows in an array to return a value e.g. match a number, let's say 4 from an array of 20 numbers but you only want to compare number 4 from rows 2,3,9,13,15,17 and 18 and not all 20 rows? Look to be possible using IF and OR functions but wondering if you have other suggestions. Thanks!!
Thank you :) just what I needed
Thanks, very clearly presented - keep up the good work! Question for you - how would you match to multiple rows in an array to return a value e.g. match a number, let's say 4 from an array of 20 numbers but you only want to compare number 4 from rows 2,3,9,13,15,17 and 18 and not all 20 rows? Look to be possible using IF and OR functions but wondering if you have other suggestions. Thanks!!