Search for value in multiple column and Row array and return value in first column

[Grimace]

Good evening

I have an array 20 Rows x 42 Columns, which contains a competition draw.

I need to search this array for a unique value and return whatever the time is in the first column on the same row as the value appears, and enter it into column C in the Womens Times sheet.

I also want to return into column D the court number from row 3.

The reason i want this automated is as teams enter / withdraw we may need to drag the games from court to court to fill gaps, so i want the Womens Times sheet to update accordingly.


I have been messing around with index and match, but cannot quite get it to return what i need. Any assistance would be greatly appreciated.

I have attached an example ... on the sheet "Womens Times" in column A there is a list of game numbers ( #1W etc etc) indicating womens game #1 and so on. The main sheet i am using also has a seperate tab for the mens games, hence the designator of W or M on the end of the game number.

The combined draw sheet has the full draw ....

Thanks in advance

[RobertMika]

Search%20for%20court%20time%20example(1).xlsx
Answers in columns H-K

[Grimace]

Hi Robert thanks for your help .... i was only able to try it out today and it worked great.

No need for the reminder about reputation .. i always do once I have a chance to assess the replies.

Have a good day.

Darren