Consider the below data. For example, I want to search for "ghi" (will occur only once) in an array (A1:D5 here, much larger in actual data), then count the number of times E occurs in the 4 rows above in same column. I've used VLOOKUP going horizontally, but this is vertically. I've tried HLOOKUP with no luck and maybe that's totally off base.
ColA ColB ColC ColD
Row1 A E A E
Row2 B F B F
Row3 D E A F
Row4 D H D H
Row5 def ghi jkl mnp
Thanks,
roothog
Bookmarks