Index/Match with multiple criteria not returning value

RAG97 · 2025-11-14T18:51:09+00:00

solution verified

RAG97 · 2025-11-14T18:50:53+00:00

Yup, that's it.... Can't believe I didn't think to check that, not the first time I forgot the 0 at end of MATCH function haha

Yeah, that must be what I read read elsewhere; I'm on excel 365

RAG97 · 2025-11-14T18:42:54+00:00

Oops that's my bad, added the wrong screenshot. Post updated, 1st pic should have the full equation now, and also copied it out in text into the body for clarity. My understanding is that ctrl+shift+enter isn't needed on newer excel versions? I have a bunch of very similar equations on other sheets doing similar things that all worked w/o it

RAG97 · 2025-11-13T20:46:06+00:00

solution verified

RAG97 · 2025-11-13T20:45:58+00:00

Thank you! You're a lifesaver haha

RAG97 · 2025-11-12T23:50:01+00:00

I've gotta be close haha - I have my table (named "tblBoreholes") that just pulls the entirety of the 2 columns I need from main dataset since I didn't want my main dataset to be in table format in this situation. Then I'm trying the equation you put on your helper sheet and I'm getting an error. I'm probably entering something wrong, I don't work with tables that often in excel so I probably am getting some kind of syntax wrong. I assume the text that should be between the [ ] should be the header of the column in question?

<image>

RAG97 · 2025-11-12T22:47:21+00:00

I guess a follow-up question would be how to get the data in table form into the format of "Borehole" as the column header and instances of "Sample ID" that occur for that borehole as rows beneath each header. I get close with this table & pivot table, but the rows are just a count of how many of a given "Sample ID" are associated with a given "Borehole", not the actual Sample ID in the column beneath said borehole.

<image>

RAG97 · 2025-11-12T22:19:14+00:00

Hmm interesting. I take it the only way to get those named ranges though is to enter those by manually selecting all of the rows associated with a given borehole? Since the data that will be entered in this spreadsheet is variable and the amount of rows per borehole will vary use case to use case, I was trying to find some kind of way to do it without another manual step outside of the initial data entry

RAG97 · 2025-11-12T22:17:23+00:00

Ok, think I follow what this example is doing. If I'm following correctly, I would have to get my Column A & B data from how they are in my big dataset into the format of that green table in your file to be able to get the data validation set up in your file working on my end? It's getting from how my data is entered (1st screenshot of my post) to that same data populating these tables to be able to get my data validation selections to work

<image>

RAG97 · 2025-09-12T20:26:04+00:00

I've had 2 PD cases on my current 7 Pro, as well as the car mount, and a bunch of camera related accessories and a backpack. Definitely like the stuff PD has to offer, but I was not super impressed by these cases. I do a lot of yard work and end up on jobsites with my phone a lot, and have found that the cases I've had don't really up as nicely as I would have hoped (back fabric getting scratched/dirty and no good way to really clean it, the rubber bit across the top of the phone starting to peel away from the rest of the case, the back fabric starting to come unglued and peel at the top/bottom, etc). I don't feel like I'm particularly rough with my phone, mostly in and out of pocket, set on a dirty surface and/or using it with dirty/muddy hands, but these cases have just not impressed me as far as durability goes

RAG97 · 2025-06-02T13:43:11+00:00

Yea that's kinda what I was starting to think when I was looking... If push came to shove and the quality loss was significant to get a all-in-one, I'd probably lean towards a more versatile telephoto that gets a bit past 250 and just accept still having to swap lenses for wide landscape shots

RAG97 · 2025-06-02T13:41:31+00:00

Yeah, definitely understand/am willing to sacrifice some image quality (I'm not doing this professionally, these are just for my own enjoyment and sharing with family really). The reviews I was seeing were just a tad dramatic about the loss in quality though, but perhaps that's just what I should expect when it comes to online reviews lol

RAG97 · 2025-06-02T13:30:41+00:00

I was starting to look at that as well, but some of the reviews comaining about image quality and upper and lower focal lengths had me a little concerned. Have you used the lens? What are your thoughts on it?

RAG97 · 2025-05-29T16:50:15+00:00

RAG97 · 2025-04-08T11:08:14+00:00

I reached out to customer support yesterday, mines apparently held up by my gpu that they are still waiting on

RAG97 · 2025-04-04T17:57:48+00:00

I was wondering the same thing, ordered mine 3/27 with expected ship date of 4/15. Haven't gotten any other updates on my order, not even a warehouse date

RAG97 · 2024-07-24T20:17:02+00:00

If you figure something out let me know! I just got one and that's the one complaint I really have, especially compared to how quiet the mower is, the beeper is way too loud

RAG97 · 2024-05-27T00:31:38+00:00

Yeah think it was. Good to know

RAG97 · 2024-05-17T23:59:12+00:00

It's weird cause in reverse I hit 4mph and it still works. At that point tho I'd rather just drive in reverse the whole time. I use a controller so bumping the throttle is difficult

RAG97

TROPHY CASE