I have a spreadsheet of expense values by month. The rows represent different expense categories; the columns months.
I would like to search for the row whose first value matches "abcdefg", for example. I tried the following statement but it's erroring out:
select(@Income Statement,1:150;, (@Income Statement,A:A;="abcdefg"))
I assume there is a problem with the first parameter in the select() function, but I wasn't sure what it should look like. I need to search all of the rows in the spreadsheet to find the correct row. My row will always be called "abcdefg", but I have no guarantees that it will always be row 9, or whatever. So I cannot just simply click that row.
Thanks for your help!