英文:
Googlesheets: get data from a cell which contains a few string
问题
Initially I use =transpose(IMPORTXML("https://www.coingecko.com/en/watchlists/all-time-high-crypto","/html/body/div[4]/div[6]",3)) to get a list of coins data.
However, it is not in a table form and it is `
How can I use VLOOKUP (or any method) to find ETH and get the data for ATH which is $4,878.26?
英文:
Initially I use =transpose(IMPORTXML("https://www.coingecko.com/en/watchlists/all-time-high-crypto","/html/body/div[4]/div[6]",3)) to get a list of coins data.
However, it is not in a table form and it is `
How can I use VLOOKUP (or any method) to find ETH and get the data for ATH which is $4,878.26?
答案1
得分: 1
=index(xlookup(B1&"",trim(A:A),--regexextract(A:A,"ATH:\s+$(.?) "),,2))
英文:
You may try:
=index(xlookup(B1&"*",trim(A:A),--regexextract(A:A,"ATH:\s+$(.*?) "),,2))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论