Get unexpected #VALUE when using IMPORTHTML

4 views
Skip to first unread message

Fred Mirtz

unread,
Jan 20, 2025, 4:19:23 PMJan 20
to Google Sheets Community
I am using the following:
=if(SEARCH("etf",IMPORTXML("http://finviz.com/quote.ashx?t="&A15,"//title")), "T", "F")

in cell A15 is the ticker AGNC.  I would expect the cell that contains this formula to contain "F" but it says "#VALUE".  What am I doing wrong?

It works if the $A15 contains the ticker FIDI.

Thanks
Fred

Fred Mirtz

unread,
Jan 21, 2025, 7:57:04 PMJan 21
to Google Sheets Community
Fixed it.  Working now.

Thanks for the help
F
Reply all
Reply to author
Forward
0 new messages