i have a problem with a vlookup and also index&match formula.
First i transpose split and substitute a result from an api call which is in JSON, then i get a list i can use vlookup with, but when trying the result is allways #N/A.
=transpose(split(H7;",")) and =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E18;"[";"");"]";"");" ";"") are the formulas to get a short list of numbers i would like to use a search for a result and this is existing, because when i replace the formula with the result for what i am looking for with a "normal number", then i get the response from a vlookup or index&match!
Would be cool if someone has an idea for this so i can bring it to work.
It turns out as necessary to delete empty rows from other related sheets without content in it to make it happen to work for this kind of sorting data with index and match.