Hi -
So, I am trying to develop a formula which would display the first 0-10 values in a column on Sheet 1, which have an X next to them in Sheet 2. Problem being, on Sheet 2 there will often be blank rows (those which do not have an X next to them) between those that do have Xs on SHeet 2.
I've tried using an index/match function... am close... but not there yet.
See attached sheet.
Help!
Jacob
Index Match Example.xlsx
Bookmarks