excel help needed

C

chrisj900

Senior member
 whitley bay/ newcastle
is currently setting up my new betting spreadsheet but i want to make my life a little easier. every day i will be importing the latest stats for the 30 NBA basketball teams with the teams going from A1-A30 then the stats going across the page. there are 2 self calculating columns for each team running in AA 1-30 and AB 1-30

in a separate table the competing teams will be listed side by side A35 and B35, A36 and B36 etc. in the next 2 columns (C35 and D35) will be the calculated figures for the home team and (E35 and F35) will be the calculated figures for the away team.

is there an equation that will automatically bring down these figures when i enter the team name??? so if i enter miami heat vs newyork knicks, the spread sheet will automatically find the corresponding rows for these 2 teams from table 1 and copy the data from the 2 specific cells on each row down into the second table.

any help would be much appreciated as i'm good with the maths but not excel. also i am not a fan of basketball.i actually have no understanding of the game, its just an easy sport to bet on
 
sounds feasible using 'if...else if...else if...else...end if'. may get a bit cumbersome to enter into cells directly so some macros or visual basic functions would make life easier possibly.
 
Hi there... long time lurker here with a 3.0 E85.... The formula you are looking for is "VLOOKUP"....
 
if you select data-validate and the list of names you should be able to create a drop down list, then next a vlookup should return the number, (odds?), you're looking for.
 
Jamz said:
Hi there... long time lurker here with a 3.0 E85.... The formula you are looking for is "VLOOKUP"....
Click to expand...

Yep the VLOOKUP (vertical array look up) function will do this.
 
You must log in or register to reply here.
Back
Top Bottom