| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index and Indirect formula help...
I have a bunch of tabs in my spreadsheet and each one is named after a team
(i.e. BOS, NYR, VAN, etc.). In column AA I have text and in column W I have team names. I would like a formula to lookup the text in column AA in the tab of the team that is in column W. For example in cell AA3 I have Dec 18-Pittsburgh and in cell W3 I have NYR. I would like a formula to find the text Dec 18-Pittsburgh in the NYR tab and give me the value of the cell 4 columns over. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Index and Indirect formula help...
anyone know what formula I should use? Thanks.
"Jambruins" wrote: I have a bunch of tabs in my spreadsheet and each one is named after a team (i.e. BOS, NYR, VAN, etc.). In column AA I have text and in column W I have team names. I would like a formula to lookup the text in column AA in the tab of the team that is in column W. For example in cell AA3 I have Dec 18-Pittsburgh and in cell W3 I have NYR. I would like a formula to find the text Dec 18-Pittsburgh in the NYR tab and give me the value of the cell 4 columns over. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
| Match, Index, Indirect ? | Excel Worksheet Functions | |||
| Index,Indirect, and Match | Excel Worksheet Functions | |||
| Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
| Indirect vs. Index | Excel Discussion (Misc queries) | |||
Linear Mode
