Formula that I am using is the following: INDEX({Range 1}), MATCH({Search value}, {Range 2}, 0)). In this formula Range 1 and Range 2 referencing another sheet and Search value referencing the value in the current sheet. The value in the current sheet is also based on formula and when using INDEX, MATCH with search value cell with formula, INDEX is returning the following: #NO MATCH. My guess is that because in the other Smartsheet table that I am referencing for Range 2 the range consist of numbers while Search value in the current sheet consists of formula based numbers. When I convert Search value column from formulas to text, formula still doesn`t work and shows the same NO MATCH outcome. When I delete the cell content in the Search value and type the number manually then INDEX, MATCH formula works but this way simply manually retyping will take a long time. When I am adding ISNUMBER function in the INDEX, MATCH formula it works only for cells where Search value represent only digits but when cell contain also letters it doesn`t work.
Is there a way to make INDEX, MATCH formula work for Search value numbers where formula is used for the whole column?
