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