New Posts For Thread: Excel formula help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/29776023/excel-formula-help-pleaseam a beginner in excel 2010 been trying all day to sort this so now have to resort asking for help from you guys pleasetrying to get data from sheet called ratings plusam using this formula but obviously not right =IF(M2="","",IFERROR(VLOOKUP(M2,'ratCommon is the trailing space.https://community.betfair.com/general_betting/go/thread/view/94082/29776023/excel-formula-help-please?post_id=529116995#529116995Common is the trailing space.Sun, 17 Feb 2013 11:49:59 -0600no upper/lower case will give the same result. Try =len(M2) to check the string length of each horse. I imagine you probably have a leading/trailing spacehttps://community.betfair.com/general_betting/go/thread/view/94082/29776023/excel-formula-help-please?post_id=529115451#529115451no upper/lower case will give the same result. Try =len(M2) to check the string length of each horse. I imagine you probably have a leading/trailing spaceSun, 17 Feb 2013 10:55:39 -0600I get false when I try thatRocknrollramboROCKNROLLRAMBO in uppercase will that make a differencehttps://community.betfair.com/general_betting/go/thread/view/94082/29776023/excel-formula-help-please?post_id=529115387#529115387I get false when I try thatRocknrollramboROCKNROLLRAMBO in uppercase will that make a differenceSun, 17 Feb 2013 10:53:51 -0600Check if the horse names are the same in each sheet as the formula definitely works. You may have a rogue space or extra character. A quick test is say cell M2 and X5 contain the same horse names then formula =M2=X5 should calculate to TRUE if they mhttps://community.betfair.com/general_betting/go/thread/view/94082/29776023/excel-formula-help-please?post_id=529115275#529115275Check if the horse names are the same in each sheet as the formula definitely works. You may have a rogue space or extra character. A quick test is say cell M2 and X5 contain the same horse names then formula =M2=X5 should calculate to TRUE if they mSun, 17 Feb 2013 10:49:24 -0600no good just get 0https://community.betfair.com/general_betting/go/thread/view/94082/29776023/excel-formula-help-please?post_id=529114703#529114703no good just get 0Sun, 17 Feb 2013 10:31:13 -0600Give this a go=IFERROR(INDEX('ratings plus'!D:D,MATCH(M2,'ratings plus'!C:C,0),0),0)https://community.betfair.com/general_betting/go/thread/view/94082/29776023/excel-formula-help-please?post_id=529114513#529114513Give this a go=IFERROR(INDEX('ratings plus'!D:D,MATCH(M2,'ratings plus'!C:C,0),0),0)Sun, 17 Feb 2013 10:26:43 -0600am a beginner in excel 2010 been trying all day to sort this so now have to resort asking for help from you guys pleasetrying to get data from sheet called ratings plusam using this formula but obviously not right =IF(M2="","",IFERROR(VLOOKUP(M2,'rathttps://community.betfair.com/general_betting/go/thread/view/94082/29776023/excel-formula-help-please?post_id=529114353#529114353am a beginner in excel 2010 been trying all day to sort this so now have to resort asking for help from you guys pleasetrying to get data from sheet called ratings plusam using this formula but obviously not right =IF(M2="","",IFERROR(VLOOKUP(M2,'ratSun, 17 Feb 2013 10:21:24 -0600