| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and Index...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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP, INDEX, or ....? | Excel Worksheet Functions | |||
| INDEX? VLOOKUP? | Excel Discussion (Misc queries) | |||
| Need Help with Index and Match or Vlookup | Excel Worksheet Functions | |||
| Index Match Vlookup or something else | Excel Discussion (Misc queries) | |||
| n/a in vlookup/index/match formula | Excel Worksheet Functions | |||
Threaded Mode
