nesting MATCH and VLOOKUP in IF_AND statement

Hi FDibbins, thank you to remind me that it's usefully to read the rules not just to check the box when one fill in the register form. I'm apologize for doing that. I appreciate your tolerance.

Now I will return to the purpose of the post. I'm trying to use MATCH function (TBLs!B12; TBLs!B13; TBLs!E12;TBLs!E13) as a logical tests in IF and AND statement. I want for home team (DATA!H) or away team (DATA!I) to get the result (DATA!P for home team; DATA!Q for away team) only if both logical tests (A12 MATCH in DATA!C and B1 MATCH in DATA!H for home team), (A12 match in DATA!C and E1 MATCH in DATA!I for away team) are TRUE, if either is FALSE I want formula to point me that team played HOME or AWAY in the corresponding round. I also tried to used VLOOKUP function (TBLs!B2; TBLs!B3; TBLs!E2;TBLs!E3), but by both of these efforts I constantly get irrelevant results and I can't resolve it.

I will appreciate to all you for help me to resolve that problem.

Have a great day,
Rosen

Hi and welcome to the forum

Please take a minute to read forum rule #1...

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title"

Also, i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Thanks for the title change and for the understaning

for table 1, use this array formula...
=IFERROR(INDEX($A$2:$G$50,MATCH(J$1&$I2,$A$2:$A$50&$B$2:$B$50,0),COLUMN(D$1)),"AWAY")

And fot the away results, use this array formula...
=IFERROR(INDEX($A$2:$G$50,MATCH(J$1&$I20,$A$2:$A$50&$C$2:$C$50,0),COLUMN(D$1)),"HOME")

confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Once you have the 1st 1 in, copy/paste down and across. repeat for the 2nd 1

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Thanks for the feedback