have pasted this in general as well not sure which of you is more equipped to help how 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,FALSE),"") and the other column I want to add is BG thanks in advance for the help