NFL Winning Margins

[scottymelloty]

I'm sure this is going to be easy for you all out there but it's beyon
me !!

When i price NFL winning margins up i have a sheet with all the margi
odds prices on. I have a sheet set up like this ready to fill my dat
in

NY JETS
-2.5 (Handicap)

1-6 --------- (paste odds in next column)
7-12
13-18
19-24
...so on

I then copy and paste the winning margin odds from the other sheet int
the nextdoor column that relates to -2.5 (in this case) and so on fo
all games, is there a way that when i change the handicap under th
team name it links directly to the relating column on the winnin
margin sheet without me having to copy and paste ???

Many Thank

 

[Paul]

I'm sure this is going to be easy for you all out there but it's beyond
me !!

When i price NFL winning margins up i have a sheet with all the margin
odds prices on. I have a sheet set up like this ready to fill my data
in

NY JETS
-2.5 (Handicap)

1-6 --------- (paste odds in next column)
7-12
13-18
19-24
..so on

I then copy and paste the winning margin odds from the other sheet into
the nextdoor column that relates to -2.5 (in this case) and so on for
all games, is there a way that when i change the handicap under the
team name it links directly to the relating column on the winning
margin sheet without me having to copy and paste ???

Many Thanks

I think you need HLOOKUP formulas. These would look up your handicap in the
first row of an area on the other sheet, and return data from the column of
that area below the matched handicap. Have a look at HLOOKUP in Help. If you
get stuck, post back with a specific query, quoting the formula you are
using even if it isn't complete.

 

[scottymelloty]

Thanks paul, will have a go at that