New Posts For Thread: incorrect excel formulahttps://community.betfair.com/general_betting/go/thread/view/94082/23482402/incorrect-excel-formulaI'm not sure whether it's possible to do the following, but here goes=IF(G2=1,IF(B2=$B$1,VLOOKUP(E2,Index,10,IF(E2=$B$1,VLOOKUP(B2,Index,9,)))),"")I have a list of football results, and I'm trying to retrieve a rating for team B1's opponents.When B1Cheers for taking the time both of you.The one I'm using is working, more by chance, but i'll keep your suggestions close by for future use.https://community.betfair.com/general_betting/go/thread/view/94082/23482402/incorrect-excel-formula?post_id=419439882#419439882Cheers for taking the time both of you.The one I'm using is working, more by chance, but i'll keep your suggestions close by for future use.Wed, 30 Dec 2009 11:18:01 -0600This looks more right=IF(AND(G2=1,B2=$B$1),VLOOKUP(E2,Index,10),IF(E2=$B$1,VLOOKUP(B2,Index,9),""))https://community.betfair.com/general_betting/go/thread/view/94082/23482402/incorrect-excel-formula?post_id=419439826#419439826This looks more right=IF(AND(G2=1,B2=$B$1),VLOOKUP(E2,Index,10),IF(E2=$B$1,VLOOKUP(B2,Index,9),""))Wed, 30 Dec 2009 08:45:41 -0600After the 9,(at the end) it should also indicate what needs to happen, maybe another falsehttps://community.betfair.com/general_betting/go/thread/view/94082/23482402/incorrect-excel-formula?post_id=419439818#419439818After the 9,(at the end) it should also indicate what needs to happen, maybe another falseWed, 30 Dec 2009 08:28:22 -0600So you have IF(a=1,(IF b=1.......,middle bracket after comma),final term)For example. If a=1 then it processes the second IF.If a=1 and b is not =1 then it processes the middle bracket after the commaIf a is not =1 then it processes the final term.https://community.betfair.com/general_betting/go/thread/view/94082/23482402/incorrect-excel-formula?post_id=419439814#419439814So you have IF(a=1,(IF b=1.......,middle bracket after comma),final term)For example. If a=1 then it processes the second IF.If a=1 and b is not =1 then it processes the middle bracket after the commaIf a is not =1 then it processes the final term.Wed, 30 Dec 2009 08:22:56 -0600That's neat CM. (I usually use the OPs method of having nested IFs if I need more than one true. Only posting this in case, for some reason, you didn't know you could do that... although your method is nicer I think)https://community.betfair.com/general_betting/go/thread/view/94082/23482402/incorrect-excel-formula?post_id=419439810#419439810That's neat CM. (I usually use the OPs method of having nested IFs if I need more than one true. Only posting this in case, for some reason, you didn't know you could do that... although your method is nicer I think)Wed, 30 Dec 2009 08:21:02 -0600I am not to sure what you are doing ~ But ~You have 2 IF's in a sequence without telling the first IF what to do. If you want both G2=1 andat the same time B2=$B$1 you need to use AND as below=IF(AND(G2=1,B2=$B$1),VLOOKUP(E2,Index,10,FALSE),IF(E2=$B$https://community.betfair.com/general_betting/go/thread/view/94082/23482402/incorrect-excel-formula?post_id=419439802#419439802I am not to sure what you are doing ~ But ~You have 2 IF's in a sequence without telling the first IF what to do. If you want both G2=1 andat the same time B2=$B$1 you need to use AND as below=IF(AND(G2=1,B2=$B$1),VLOOKUP(E2,Index,10,FALSE),IF(E2=$B$Wed, 30 Dec 2009 08:13:56 -0600=IF(G2=1,IF(B2=$B$1,VLOOKUP(E2,Index,10,FALSE),IF(E2=$B$1,VLOOKUP(B2,Index,9,))),"")sorry this is the one that workedhttps://community.betfair.com/general_betting/go/thread/view/94082/23482402/incorrect-excel-formula?post_id=419439738#419439738=IF(G2=1,IF(B2=$B$1,VLOOKUP(E2,Index,10,FALSE),IF(E2=$B$1,VLOOKUP(B2,Index,9,))),"")sorry this is the one that workedWed, 30 Dec 2009 06:45:59 -0600=IF(G14=1,IF(B14=$B$1,VLOOKUP(E14,Index,10,IF(E14=$B$1,VLOOKUP(B14,Index,9,)))),"")That worked.https://community.betfair.com/general_betting/go/thread/view/94082/23482402/incorrect-excel-formula?post_id=419439726#419439726=IF(G14=1,IF(B14=$B$1,VLOOKUP(E14,Index,10,IF(E14=$B$1,VLOOKUP(B14,Index,9,)))),"")That worked.Wed, 30 Dec 2009 06:40:57 -0600I'm not sure whether it's possible to do the following, but here goes=IF(G2=1,IF(B2=$B$1,VLOOKUP(E2,Index,10,IF(E2=$B$1,VLOOKUP(B2,Index,9,)))),"")I have a list of football results, and I'm trying to retrieve a rating for team B1's opponents.When B1https://community.betfair.com/general_betting/go/thread/view/94082/23482402/incorrect-excel-formula?post_id=419439718#419439718I'm not sure whether it's possible to do the following, but here goes=IF(G2=1,IF(B2=$B$1,VLOOKUP(E2,Index,10,IF(E2=$B$1,VLOOKUP(B2,Index,9,)))),"")I have a list of football results, and I'm trying to retrieve a rating for team B1's opponents.When B1Wed, 30 Dec 2009 06:16:32 -0600