You see over here in Cell A13 it's says Bar soap. By the way, the shortcut to move from one worksheet to another, you could press Ctrl+Page Down to get to the next worksheet and Ctrl+Page Up to go to the previous worksheet. It makes it a lot easier on you to make sure that they are consistent. And this is important because when you do a workbook that has multiple sheets of the same type of data. I really dont want to have to enter every worksheet name and the fact I add more worksheets from time to time. The columns are the same, the rows are the same, everything is the same. Any of my 80 worksheets A1 Return value from matching worksheet C2 Maybe its the lack of coffee, but I just can not find an answer how to have the values from multiple sheets checked. In other words, in an Excel reference to another worksheet, you use the following format: Reference to an individual cell: Sheetname Celladdress. The only thing that's different is the data. To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark () before the cell address.
So click on the South region and click on the East region and click on the West region and you see each of these are almost identical. We can see up here it tells us also what region we're in and let's just click on them. This workbook has data in four different worksheets and you can see down on the bottom, we have worksheets for different regions of the company, North, South, East and West.
