Pulling Data from one Table to another

Amateur Exceler here! I have tried VLOOKUP and am not getting the results I need. (I could be using it incorrectly). Trying to get the results that I will manually enter in the first table, to populate the second and third tables as I have shown. (I only manually entered them in, but I want to to automatically fill over.) There will be 2 pools of players (A and B) And I will add them to the table on the left as they sign up. I want the second and third tables to auto fill with the players in their designated pools and have their score from the (Best 2) Column to accompany them there in hopes I can just quickly sort them in ascending order at the end for payout purposes. Thanks in advance for any help


Capture 1.PNG

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

For the following to work, you will need to complete the names of each player in the appropriate pool

In Z4 {=IF(Y4<>"",INDEX($V$4:$V$23,MATCH(1,($B$4:$B$23=$X$3)*($C$4:$C$23=Y4),0)),"")}
The curly brackets are added when you enter this by holding down the Ctl + Shift+ Enter keys. Do not add the brackets manually as the formula will fail.

In AD4 {=IF(AC4<>"",INDEX($V$4:$V$23,MATCH(1,($B$4:$B$23=$AB$3)*($C$4:$C$23=AC4),0)),"")} Apply the same principles as above.

With this scenario, I am unable to determine a sorting function as it appears to be disabled in the filters you have applied.

To auto fill the names, you will need to apply a VBA scenario.

That will require a VBA solution. Are you comfortable with that.

Ok. Here is some further information and a VBA solution

1. The tables in columns X:AD need to be reverted to ranges otherwise this will not work
2. The data in Row 25 needs to be moved somewhere other than beneath columns X:AD or this will not work

Here is your VBA code

Please Login or Register  to view this content.

Standard Module
How to install your new code
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:
Press Alt-F8 to open the macro list
Select a macro in the list
Click the Run button