Multiple criteria lookup??

**jjm90sc** · 06-27-2013, 02:07 PM

Hello,

I am trying to pull data from a part of a colum (A5:A16) on one worksheet into a cell on another worksheet based on the date and a position (1, 2, 3, or 4). Here is the sheet that I am trying to pull from:

Scheduling sheet.jpg

And here is the sheet that I am trying to automate:

Talley Sheet.jpg

I have been able to automate some of my workbook using conditional formatting and some nested IF statements.

I am sure that there is something useful that I am forgetting to tell you about, so please let me know what further information would be helpful.

Thanks,
John McDonnell

**martindwilson** · 06-27-2013, 02:30 PM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**jjm90sc** · 06-27-2013, 02:56 PM

Thanks for the response. I have attached what I believe you asked me for with a before and after tally sheets.

**AZ-XL** · 06-27-2013, 03:06 PM

Hi.
Paste the formula to c7 cell in After Tally Sheet
=INDEX('Play Availability'!$A$5:$A$16,MATCH('After Tally Sheet'!A7,INDEX('Play Availability'!$E$5:$AC$16,,MATCH('After Tally Sheet'!$E$3,'Play Availability'!$E$3:$AC$3,0)),0))

When you cjange the date it brings Names
Uploaded file

**jjm90sc** · 06-27-2013, 05:10 PM

AZ-XL,

That is awesome! Thanks!

-John

**jjm90sc** · 06-27-2013, 08:56 PM

Again this answer did the trick! I am going to play with now bring over the handicap index from that worksheet and then have it use the formula that I have on the play availability page (Colums c and d) so that I hopefully can better understand the order of the functions that you provided.

If I mess it up, you'll hear from me soon!

Thanks!