Index and Indirect formula help...

J

Jambruins

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and Index...formula help 12
combinations 11
find a number in a cell 21
Indirect 1
Indirect or Index or something else 1
Formula alteration help! 5
Need a formula to do the following... 4
if(isna(match formula 8

Top