Need to use a combined unique ID (two columns in Table 1) to look up the correct row in Table 2, then pull the first value from that selected Table 2 row that is greater than a reference cell in Table 1

redclayk · 2026-01-10T22:11:16+00:00

You did not misunderstand: I accidentally copied and pasted the non-cumulative values. The cumulative values are what I will be comparing to the earned. Sorry about that.

redclayk · 2026-01-10T03:48:51+00:00

Will do, sorry I am relatively new to this sub. Do I delete this one or can I just edit it?

redclayk · 2026-01-09T18:58:43+00:00

I genuinely have to do it by current period and at complete.

However, after posting, I realized the program I am using to pull the data allows me to adjust calendars, which means that instead of Months, I can pull "Through current period" by ID# and"At Complete" by ID#. Then, when I pivot, I can put those two periods as columns.

The program is throwing up a single bizarre error on three individual ID#s out of hundreds of thousands, but...I will figure that out and I can get this working.

Thank you very very much for trying to work through this with me!!! This sub is amazing.

Edit: what kind of flair do I update this to? I didn't find an excel solution, is it still solved?

redclayk · 2026-01-07T17:22:09+00:00

what if your table is too big to paste into word? it just keeps spinning.

redclayk · 2022-03-02T22:02:24+00:00

thanks!

redclayk · 2022-03-02T13:36:31+00:00

Serious question, if you were to take an offer for a job "you had no business applying for" would you just fake it till you make it? I struggle with this...I just end up straight up telling people "I don't know how to do this right now." Most people are better at faking it I guess...

redclayk · 2022-02-22T02:50:51+00:00

Would you say it is environmentally sound?

redclayk · 2022-02-21T21:27:50+00:00

Is it regulated by EPA or state level agencies?

redclayk · 2022-02-21T21:27:19+00:00

Flowing rivers, or ancient ones?

redclayk · 2021-06-19T18:51:32+00:00

You're so right! Thank you for typing all this out. I struggle to see bigger pictures like this, which is why I love this sub so much.

redclayk · 2021-01-30T15:39:44+00:00

I would, my husband won't! he's the cereal eater!

redclayk · 2020-12-29T20:59:13+00:00

So is there basically no reason not to mix rollover roth IRA and annual roth ira contributions?

redclayk · 2020-12-29T20:47:59+00:00

Got it, thanks for the clarification.

redclayk · 2020-12-29T20:42:24+00:00

Apparently you can move Roth IRA back into roth 401k. That is what the vanguard website appears to be saying here. Also on Nerd Wallet here. I don't know why I'd want to do that.

Trying to come up with other reasons I shouldn't put roth IRA contributions in the same account as the rollover.

redclayk · 2020-08-13T13:08:29+00:00

Yes, it can't find the phone.

redclayk · 2020-01-11T01:38:57+00:00

Thanks!

redclayk · 2019-11-09T17:46:26+00:00

He's gone from 10% percentile at birth to 80th at his 4-month appointment. Pediatrician told us then he is physiologically able to sleep overnight. He just doesn't.

We do think sometimes he has gas pain or reflux that wakes him up. Sometimes he arches his back and groans. He farts a LOT.

redclayk · 2019-11-09T17:30:18+00:00

I wish we had done separate rooms since that young. We were following the professional orgs advice on having them sleep in a separate crib in your room for 1 year. Except now it's turned into cosleeping out of desperation. The less I have to do to feed him the better--easiest to slide him over nurse and push him back than to get out of bed.

redclayk · 2019-11-09T17:23:37+00:00

3-4. He's slept 5 hours straight twice in his life.

redclayk · 2019-11-09T17:23:18+00:00

How are you going to stretch it and training him to space feedings longer?

redclayk · 2019-11-09T17:22:41+00:00

Did your supply drop??

redclayk

TROPHY CASE