based

Excel Reference Another Sheet Based On Cell Value. A single quote character is joined to either side of c$4 using the concatenation operator (&). Press the equal sign, and then click on the worksheet that contains the source data.

Select a blank cell (here b3) to place the hyperlink, copy and paste the below formula into it. The first method is a more manual method, that involves the use of filters to extract the rows that match a given cell value. If you want to get values in the same cell (such as b10) across multiple sheets in current workbook, and place these values in a destination worksheet, please select cell b10 in the destination worksheet firstly.