Help!
I have 2 spreadsheets. One contains data and the other (#2) is meant to read data from the 1st spreadsheet conditionally.
I want the 2nd spreadsheet to read data from every row of the 1st spreadsheet and display only the rows that contain the lookup value then populate sequentially in a row in the 2nd spreadsheet. So it will only display results if the given value is found.
The way I was doing it would leave blank rows on the second spreadsheet and i want it to fill in each row when the value is recognized.
Thanks!
Joe
Bookmarks