General Betting
There is currently 1 person viewing this thread.
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
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
sort by:
Show
per page
Replies: 1
|
By:
something like this
IF(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 column |