INDIRECT, OFFSET et. al.

G

Guest

How do I get the following formula:

=IF(ROW()=VLOOKUP($A2,$AY$1:$BC$49,3,FALSE),MEDIAN(INDIRECT(VLOOKUP($A2,$AY$1:$BC$49,4,FALSE) & ":" & (VLOOKUP($A2,$AY$1:$BC$49,5,FALSE)))),"")

to skip every 8th row. I am unsure as to how INDIRECT,OFFSET and ADDRESS
interact with each other. The formula above works for the first column, but
fails for every subsequent 8th column.

wazooli
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDIRECT(ADDRESS) inside a VLOOKUP 13
VLOOKUP and OFFSET 3
Invalid Formula with the use of Indirect 5
Indirect inside a vlookup 3
Circular reference, Indirect, and Sum 3
Indirect Vlookup with RC[-1] 6
Vlookup + Address functions combined 2
Trouble with skipping rows 1

Top