[Archived] Excel Help Required

[Ricky]

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:

  Quote

=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??

[snatchymcsnatch]

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.

[Hughesy]

Ricky if you send me the sheet and then i can see what your doing, i should be able to help you.

[BuckyRover]

If Hughesy fails I am next in line

[thebigguy]

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

[broadsword]

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.

[Hughesy]

No, You can reference data from other sheets and also from pivots.

[pksrover]

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

[Ricky]

Thanks for the offers guys, I finally managed to get my head around the vlookup function which has done the trick nicely.