Forums

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
goodyd
08 Apr 13 20:00
Joined:
Date Joined: 15 Jul 10
| Topic/replies: 108 | Blogger: goodyd's blog
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
Pause Switch to Standard View Excel formula help please
Show More
Loading...
Report JLivermore April 9, 2013 7:53 AM BST
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
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com