I have a spreadsheet that uses the following formulas
To merge data an importrange and another sheet (column J):
To sort that data based on the vlookup (=importrange record's key):
Where J has a numeric value, the data is sorted but it's pulling a bunch of null values before it gets to the populated numbers in J.
How do I adjust the =importrange results so that I can have a numerically-sorted (column J) output with the merged data?