New Posts For Thread: Excel formula help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/29850887/excel-formula-help-pleasehow do I get data from 2 different workbooks into same column, basically the data in 1 column is jumps and the data in the other column is flat so will never be same this is the formula I have now for 1 column =IF(D44"",VLOOKUP(D44,ignore!M:AR,32,FALsomething like thisIF(D44="JUMPS",VLOOKUP(D44,ignore!M:AR,32,FALSE),VLOOKUP(D44,ignore!M:BG,,FALSE)) so if d44=JUMPS it looks in one column, otherwise it looks in another columnhttps://community.betfair.com/general_betting/go/thread/view/94082/29850887/excel-formula-help-please?post_id=531119023#531119023something like thisIF(D44="JUMPS",VLOOKUP(D44,ignore!M:AR,32,FALSE),VLOOKUP(D44,ignore!M:BG,,FALSE)) so if d44=JUMPS it looks in one column, otherwise it looks in another columnTue, 09 Apr 2013 01:53:25 -0500how do I get data from 2 different workbooks into same column, basically the data in 1 column is jumps and the data in the other column is flat so will never be same this is the formula I have now for 1 column =IF(D44"",VLOOKUP(D44,ignore!M:AR,32,FALhttps://community.betfair.com/general_betting/go/thread/view/94082/29850887/excel-formula-help-please?post_id=531103689#531103689how do I get data from 2 different workbooks into same column, basically the data in 1 column is jumps and the data in the other column is flat so will never be same this is the formula I have now for 1 column =IF(D44"",VLOOKUP(D44,ignore!M:AR,32,FALMon, 08 Apr 2013 14:00:47 -0500