Ricky Posted July 14, 2008 Share Posted July 14, 2008 Just wondering if anyone can help with a formula for excel. I run a 6 aside football league and creat a weekly score sheet which I use to record the scores of the matches and who scored the goals. The sheet is automatically generated and pulls the fixtures into the relevant section. What I'm trying to do now is pull the players names in from a seperate worksheet. I want ti to check the tema name and find the squad list that relates to the team name and then display it in a box. I've done a bit of googling and I've got somewhere near by using: =LOOKUP(B14,{"Junior Bulls Athletic","Ragass Rovers","Brazilliant","Un-Nameable FC";"0-30","31-60","61-90","91-120"}) What I need to do though is find a way of replacing "0-30" etc in the second part of the formula with the correct cell from the second worksheet. as soon as I try to link it to the second worksheet I seem to be getting error messages. Any ideas anyone?? Link to comment Share on other sites More sharing options...
This thread is brought to you by theterracestore.com Enter code `BRFCS` at checkout for an exclusive discount!
snatchymcsnatch Posted July 14, 2008 Share Posted July 14, 2008 I do quite a lot of that sort of stuff and I find www.mrexcel.com to be an invaluable resource. If you get registered and post up as much relevant info as you can on there I can guarantee a prompt answer. I use it all the time when I get stuck on Excel formulas. Like I say though, the more info you post, the quicker you'll get the answer you want. Link to comment Share on other sites More sharing options...
Hughesy Posted July 14, 2008 Share Posted July 14, 2008 Ricky if you send me the sheet and then i can see what your doing, i should be able to help you. Link to comment Share on other sites More sharing options...
BuckyRover Posted July 14, 2008 Share Posted July 14, 2008 If Hughesy fails I am next in line Link to comment Share on other sites More sharing options...
thebigguy Posted July 17, 2008 Share Posted July 17, 2008 IF you are getting info from a different sheet in same document you will need to add the sheet name and the cells needed. or if a external document then the file location and sheet name Link to comment Share on other sites More sharing options...
broadsword Posted July 20, 2008 Share Posted July 20, 2008 As\ far as I remember you can't reference data from another worksheet in an excel formula, the table has to be on the same worksheet. Unless you name your look-up range on the other worksheet and reference it like that. Link to comment Share on other sites More sharing options...
Hughesy Posted July 20, 2008 Share Posted July 20, 2008 No, You can reference data from other sheets and also from pivots. Link to comment Share on other sites More sharing options...
pksrover Posted July 22, 2008 Share Posted July 22, 2008 I'm bored and got nothing to do these days so just send the file to me if you want as well and I should be able to sort it. Shame there's a few guys in front of me in the queue Link to comment Share on other sites More sharing options...
Ricky Posted July 23, 2008 Author Share Posted July 23, 2008 Thanks for the offers guys, I finally managed to get my head around the vlookup function which has done the trick nicely. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.