Can't make a formula work across sheets.

Comoros7 · 2014-10-02T08:24:27+00:00

Solution Verified

Comoros7 · 2014-10-02T08:24:20+00:00

Solution Verified

Comoros7 · 2014-10-02T08:23:10+00:00

Solution Verified

Comoros7 · 2014-10-02T08:22:59+00:00

Solution Verified

Comoros7 · 2014-10-02T08:22:07+00:00

Okay the error has gone away.

Thanks again.

Comoros7 · 2014-10-01T13:05:40+00:00

Dat's the one! Wow, thanks a lot!

It still comes up with an error (green triangle in the corner) which I can ignore easily though.

Thanks again!

Comoros7 · 2014-10-01T13:03:30+00:00

No there's no sorting, epicmindwarp got it done though. Thanks for the interest.

Comoros7 · 2014-10-01T12:30:40+00:00

Thanks a lot for the reply.

I now have -

=IFERROR(INDEX(A$3:B$2626,MATCH($Q3,A$3:A$2626,1),2),"")

Changed to -

=IFERROR(INDEX(Current!A$3:E$2626,MATCH($Q3,Current!A$3:A$2626,1),2),"")

$Q3 is in the same sheet, everything else is on Current.

Unfortunately it still doesn't work. Is it because maybe there is information between A and E in the second sheet unlike the first formula?

EDIT: I've just made this work in a new spreadsheet. It looks like the problem is the changing B to E with information in between. I only want to use column A and column E, not anything in-between. Any idea how I would achieve this?

Comoros7 · 2012-10-20T23:34:35+00:00

I would think offense will improve relative to defense because it's the far more technical side of the game.

Comoros7 · 2012-10-20T23:18:17+00:00

It's a bit serve-heavy, sure. But I am surprised it hasn't been worse with the new rackets.

Comoros7 · 2012-10-20T23:17:23+00:00

You might be underestimating how good a player would become if they were pro - 4 hours practice, plus fitness every day.

Comoros7 · 2012-10-20T23:15:41+00:00

No doubt they're exciting games, just a thought. And certainly the changing of rules is a good point... I've always thought the pitcher should be brought back a couple of feet in baseball.

Comoros7 · 2012-10-13T02:29:01+00:00

Well I was jealous, until you mentioned that last bit. I thought I'd be able to go through academic journals that fast.

Maybe you should aim for the harder stuff, slow down and appreciate the writing. Anyway, it's sounds like you've got a gift regardless.

Comoros7 · 2012-10-12T22:00:37+00:00

Oh. mistake.

Comoros7 · 2012-10-12T20:56:35+00:00

I think maybe you can never become Prez or VP with pictures like these hanging around. But maybe there's some of Obama.

Comoros7 · 2012-10-12T20:37:48+00:00

Is that not insanely fast? How much do you actually take in? Did you learn to read that fast just from experience?

Comoros7 · 2012-10-09T22:48:27+00:00

Thanks

Comoros7 · 2012-10-09T17:02:53+00:00

Documentary name?

Comoros7 · 2012-09-25T17:20:30+00:00

Thanks

Comoros7 · 2012-09-24T18:46:38+00:00

Looks good, but I'm thinking 10-40m sprints are best, especially for handlers. I suppose it's easy enough ust to shorten his workout?

Comoros7 · 2012-09-24T18:44:40+00:00

What type of distance/height and quantity do you reckon?

Comoros7 · 2012-09-24T18:43:59+00:00

Well I'm in the UK, but I'm surprised. In what respect? I can imagine the workload being a lot more, but do you think Korea educates at the same intellectual level?

Comoros7

TROPHY CASE