I want to check where - in a specified range - does a value exist in a Google Sheet. If I already know the column, I would use the "Match()" function to get the row number. But let's say if I still want to get a number for the column, and use the Match() function again, I wasn't able to. In the match function, I wanted to use a dynamic value like "Sheet1!E3" to specify the row I'm searching for, but it didn't work.