Hi Guys,
Say I have values A2:A18 on sheet 1, and a whole other sheet full of data.
How can I search my values ofA2:A18 in my other sheet and return the entire rows where this values exist?
Having trouble with using index match formula and/or advanced filtering.
Any help on how to do either or both would be appreciated.