hi,
could you help assist the below query.
i have a value(Value1) to lookup and the spreadsheet has 20 columns( Column1,Column2,…,Column20 ).
The spreadsheet has 15 rows.
Column2 tittle is equal to Value1.
how to lookup Value1 in the Column Tittles and print the values of all 15 rows?. i.e. if the column1 tittle matches the lookup value, need to print all the rows in the column.
regards
Siva.