search for a player's name, then go down x rows and across x columns to get the data.

[bfgreen4509]

please see latest post for better formed question.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[bfgreen4509]

The attachment shows a sample of the data. I need to search for a player's name, then go down x rows and across x columns to get the data.

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. Now that I have a clue what you are trying to do, and because you are new, I have changed it for you today.)

[AliGW]

The table in the attachment is not the same as the one pictured above. Where is the hole number? Where are the mocked up results?

[bfgreen4509]

sorry for not being clear enough. In this worksheet I'm attaching you will see the hole numbers going from columns E-H across row 2. Under each player name in column A is some data rows like "net Score and Stableford score" per hole. I'm interested in creating a solution to search to search for a players name, then for example, go down to the "Net Score" row and across to hole 1 column(E) to extract the data. The use case will be to compare players net or stableford scores in teams to find low scores / hole. But I am stumped with how ti index off and players names and go down and across to get the data. I do not have code to show for this because that is what I'm trying to develop for the use case mentioned.
Any help is appreciated.

[Haluk]

@bfgreen4509;

I've prepared a sample file from what I understood from your message.

On Sheet3 you will see a drop down list which you can select the player names. This list is a "Data Validation" list where it gets the data from the sheet "Helper". This sheet is used for extracting the player names from the main sheet (Sheet1) where the names are in non consecutive cells.

There is also another drop down list from which you can select the hole #.

After selecting the player name and hole #, related data will appear in the below cells.

Summary of the used formulas:

1) In your main sheet (Sheet1) I've added column A and inserted the player numbers in cells, left to the player names in column B

2) In the "Helper" sheet, there are 2 columns prepared for the Data Validation list used in "Sheet3"

To retrieve the position of the player names in the main list, i entered the following formula in cell B2 of the sheet "Helper" and copied down.

Please Login or Register  to view this content.

Then, in cell C2 of the sheet "Helper" the following formula is entered and copied down to get a consecutive range of cells housing the player names.

Please Login or Register  to view this content.

3) Then, in Sheet3 i selected cell C2 and assigned a "Data Validation" list.

The custom formula used for the data validation list is:

Please Login or Register  to view this content.

4) For the hole numbers, in "Sheet3" cell C3 i assigned another data validation list, using a custom formula:

Please Login or Register  to view this content.

5) Finally, in "Sheet3" cell C4 i entered this and copied down to get the related datas:

Please Login or Register  to view this content.

Sample file is also attached, where you can test the results.

Hope this helps...

[bfgreen4509]

Thank you very much, this is great. I should be all set from here.

[Haluk]

You're welcome...

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.