I have been receiving some help online creating a spreadsheet. So far...I have gotten what I wanted.... But I am stuck at this point...
On sheet 2 ,Values in Column A rows; values in Col B-F are multiples of ColA (12x,13x,37x,101x,111x). List pairs of Lottery names and values are in Col H/I & J/K. Using conditional formatting, values in Col A-F that match a value in Col IorJ are highlighted. My goal: 1) identify cells in ColA that match a value in Col I or J AND have one or more matching values in Col B-F on the same row; 2) display only the matching row/column values (ignore non-matching values) AND show the relevant Lottery name for matching values in Columns B-F. Could anyone assist?
On sheet 2 ,Values in Column A rows; values in Col B-F are multiples of ColA (12x,13x,37x,101x,111x). List pairs of Lottery names and values are in Col H/I & J/K. Using conditional formatting, values in Col A-F that match a value in Col IorJ are highlighted. My goal: 1) identify cells in ColA that match a value in Col I or J AND have one or more matching values in Col B-F on the same row; 2) display only the matching row/column values (ignore non-matching values) AND show the relevant Lottery name for matching values in Columns B-F. Could anyone assist?