Hi,
I have implemented a web query in excel which gathers data from the Yahoo finance stock screener. The web query works fine gathering the data from yahoo based on the parameters I have implemented from within excel.
The cells which change the parameters for the web query are in worksheet1 and the data from the web query is displayed in worksheet2
What I want to do is reference the data from the web query in worksheet2 and display the top 5 results in worksheet1.
My formula looks like this =IF(ISTEXT(Sheet5!C3),Sheet5!C3,IF(ISERROR(Sheet5!C3),"",))
this formula is copied down the first 5 cells in worksheet1 i.e. cells E1 to E5.
The formula works fine as long as the web query returns more than five results however if I narrow down the parameters giving me 3 results then I get this error in the cells that don't contain text.
=IF(ISTEXT(Sheet5!#REF!),Sheet5!#REF!,IF(ISERROR(Sheet5!#REF!),"",))
This error will then stay in the cells even when I adjust the parameters that will show more than 5 results.
Does anyone know how I can fix this?
Thanks
Bookmarks