| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Function to return value from each tab
I used to know how to do this. Can't seem to figure it out now.
I would like an entry on my first spreadsheet tab to look up the same cell reference on each spreadsheet tab depending on my entry. Then entry would be the same as the tab name. Example: I have tabs named E1, E3, E5, E8, E9. If I imput "E1" into cell C4 on my first tab I would like cell g3 (also on my first tab) to tell me what is in cell c3 on the tab named "E1". Likewise, if change my entry to "E5", I would like cell G3 on my first tab to tell me what is in cell C3 on tab E5. I used to use =IF statements to do this with. But, Excel only allows 7 nested =if statements and I have more tabs than that. Help is VERY appreciated. Steven Leuck |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need IF function to return 0 if it finds a one out of three words | Excel Worksheet Functions | |||
| Return value with using Excel function | New Users to Excel | |||
| Function to look at two cells and return a third | Excel Worksheet Functions | |||
| Error Return Value from and INDEX(A:2,MATCH()) function | Excel Worksheet Functions | |||
| Function to return colour of formatted cell | Excel Worksheet Functions | |||
Threaded Mode
