OK,Formula:Please Login or Register to view this content.
returns data IF "whatever" is at Sheet2!A9
There is a "whatever" of different kinds on every 9th row going down Col A Sheet2.
As it is now the formula needs to be modified for each subsequent query after A9.
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
If at all possible I want this formula to increase both the !$A$9 and
the !A9 by 9 each time the formula is copied and pasted down into another cell
and do it automatically. Maybe *9 and "" in the right place and proper
use of the $ would do it. Sample? Thank you
Bookmarks