cpg84
Active Member
- Joined
- Jul 16, 2007
- Messages
- 266
- Platform
- Windows
Hi,
I want to find a name in a table and return what the value of the cell next to it is. Here's a basic layout of the table:
Champion Townsville
Runner Up Singapore
Lost SF Cairns
Lost SF Melbourne
Lost QF Brisbane
Lost QF Sydney
Lost QF Adelaide
Lost QF New Zealand
9th Wollongong
10th Perth
11th South
12th Gold Coast
13th West Sydney
For each team I want to see where they finished. E.g. For Townsville, it will say Champion and so on down the list. The cell that I want their "finishing position" to appear in, is on a different worksheet to the table.
Any help would be appreciated. Im totally confused between MATCH and LOOKUP, maybe there is a better formula.
Thanks
I want to find a name in a table and return what the value of the cell next to it is. Here's a basic layout of the table:
Champion Townsville
Runner Up Singapore
Lost SF Cairns
Lost SF Melbourne
Lost QF Brisbane
Lost QF Sydney
Lost QF Adelaide
Lost QF New Zealand
9th Wollongong
10th Perth
11th South
12th Gold Coast
13th West Sydney
For each team I want to see where they finished. E.g. For Townsville, it will say Champion and so on down the list. The cell that I want their "finishing position" to appear in, is on a different worksheet to the table.
Any help would be appreciated. Im totally confused between MATCH and LOOKUP, maybe there is a better formula.
Thanks