New answers tagged


The following setup will return the last price for NASDAQ 100 Index (NASDAQ Calculation) A1: A2: =//tr[contains(.,'NASDAQ 100 Index (NASDAQ Calculation)')]/td[4] A3 Formula: =IMPORTXML(A1,A2) A3 Result: 4,512.54


importrange is not going to reorder any rows. It only imports data. The root cause is poor data structure: the second spreadsheet (with expenses) does not carry any information on whose expenses are those. This should not be acceptable data management: each table must have a column that can be used as an identifier. (Ideally, a numeric Id of an employee, ...

Top 50 recent answers are included