on this report I have an IMPORTXML function in Column B which is crawling a URL for the closing date specifically. URLS on column A

It mostly works fine, but on a couple of instance it will retrieve a #REF!, and the reason is stated as "Array result was not expanded because it would overwrite data in B58." This is happening in Cell B57 currently

anyone know how I can fix this?

Thank you

CodePudding user response：

use limit like:

=QUERY(FLATTEN(IMPORTXML(A59, "//*[@id]")), 
 "where lower(Col1) starts with 'closing date' limit 1", )