Mr Excel & excelisfun Trick 98: Extract & Lookup Number When Table Of Numbers Is In A Single Cell
Download workbook: people.highline.edu See Mr Excel and excelisfun use two methods to: 1. Check whether Numbers In Cell C2 Also In F2? 2. Mr Excel does VBA solution 3. Excelisfun does Formulas Solution. See how to increment the numbers 1, 4, 7,… with ROWS Function; extract Characters from a cell with MID function.; use MID function and array constant to create a lookup table from data in a single cell; Use MATCH and ISNUMBER functions to check whether or not numbers in cell C2 are also in F2.
Mr Excel’s idea of this formula is MUCH better:
=ISNUMBER(SEARCH(B5,$F$2))
Than this:
=ISNUMBER(MATCH(B5,MID($F$2,{1,4,7,10,13,16},2),0))
POINT to Mr Excel for knowing VBA and seeing that FIND or SEARCH is much easier!
wow!!