obtaining varying position cell value from different sheet

[chilli76]

Hi guys

Hope this makes sense.

I want to automate the process of updating my football stats and have delved into getting my data from the web. I have managed to import a football league onto my "standings" sheet but I want my "strengths" sheet to read it's values from this new "standings" sheet.

The "standings" sheet is broken down into 2 tables (home & away) one above the other.

The values I want are Home Games, Away Games, Home Goals For, Away Goals For, Home Goals Against And Away Goals Against from both the home table and the away table. The main problem I have is that the cell information I need is likely to change as I update the league tables from the web. So say one week Team A's data is in row 7 the following week it could be in row 8 so i need the data to correlate with the team name cell in my "strengths" sheet.

So at the moment Atromitos Home games (cell B8 on my strengths sheet) needs the value from cell C8 on my "standings" sheet but by next week it could need the value from C9.

Hope this makes some kind of sense.

Cheers

Ps I am assuming that I can just just hit the refresh button on the ribbon and the data from the web site will update. Is this correct?

[ragulduy]

Take a look in the helpfile at the =VLOOKUP() function

[chilli76]

Thanks for your reply

OK tried that can't seem to get it to work.

Can you see a problem with the formula?

=VLOOKUP(A5,home!$B$4:$C$28,3,0)

The cell I want to return is currently on my "home" sheet (had to split the standings in to two sheets (home and away) in cell C16. The lookup cell is in B16.

[ragulduy]

Hi, your range has 2 columns but you request the 3rd column to be returned. Maybe you ened:
=VLOOKUP(A5,home!$B$4:$C$28,2,0)

[chilli76]

excellent thank you, works a treat.

God only knows where I got the 3 from.