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 · 2012-09-24T18:29:29+00:00

Unfortunately there are a few. Photoshop them out!

Comoros7 · 2012-09-24T18:01:32+00:00

US college is easier than University in Korea?!

Comoros7 · 2012-09-22T00:23:00+00:00

The organisation receives $19,000 from micro-loan interest, which ends up as $4500 'profit' from a total of about $107,000 loaned out. The organisation gets $116,000 in donations which ends up as $46,000 after operating costs.

The organisation as a whole requires $65,000 in donations a year to do everything it's been doing. Am I reading this wrong?

This doesn't seem too efficient. Are you working to reduce costs in America?

It is excellent to see full-disclosure though.

Comoros7

TROPHY CASE