VBA Loop to get Cell Strings based on two criteria

aussie_striker

New Member
Joined
Jul 22, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have a workbook that a ladder and competition fixtures. What I am trying to do is get the next 3 rounds opposition to display on the Ladder sheet. I cannot think of anyway that I can do it using formulas so think vba is the better option. If you can think of a formula to do it I'm open to suggestions.

The excel2 image shows the ladder sheet and the result I am after noting that I have reduced the name down using a left command taking off the last 14 digits. I also added the current ladder position of the team using a index match lookup to the ladder. This would be the preferred format if achievable.

The excel1 image is the fixtures sheet. I'm thinking it will need to look up the row that matches the ladder sheet ie 4, 5, 6. as well as having the team corresponding to the one on the ladder. Then it has to determine if it is in column F or column H and return the opposite column result.

The loop would come into doing it for each team then for each round. I'm guessing a loop inside a loop to achieve it.

Hope that makes sense.
 

Attachments

  • Excel1.png
    Excel1.png
    71.3 KB · Views: 1
  • Excel2.png
    Excel2.png
    80.1 KB · Views: 1

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,113,935
Messages
5,545,100
Members
410,656
Latest member
Hydraulics
Top