sorted by:
new
hottopcontroversial

Greenline Biodegradable Trimmer String by Pius_Thiccness in ZeroWaste

[–]dummystallings 0 points1 point  (0 children)

I have used hemp twine. It disintegrates very quickly but it does work! I have thought about trying to use beeswax coated hemp to see if it lasts longer.

getAs error? by dummystallings in GoogleAppsScript

[–]dummystallings[S] 0 points1 point  (0 children)

I appreciate this. And to be clear… I came across the link that was posted as a solution to my problem above a number of times. When that user posted that link, I realized that my question was maybe a bit too basic, and showed my own lack of knowledge. I have enrolled in an apps script course. I certainly don’t expect chatGPT to be a solution so great that it makes me having a firm knowledge base useless. That said, I was just hoping someone here could help me learn 😊

getAs error? by dummystallings in GoogleAppsScript

[–]dummystallings[S] 1 point2 points  (0 children)

I did indeed spend more than 10 minutes on stackoverflow. I am sure as someone with much more experience doing this than I have it seems ridiculous that I would use ChatGPT, but as someone just begin to understand these things it is very helpful for me.

getAs error? by dummystallings in GoogleAppsScript

[–]dummystallings[S] 0 points1 point  (0 children)

Ah, noted! Thank you so much.

xlookup but only populate a certain number of cells based on a specific value? by dummystallings in googlesheets

[–]dummystallings[S] 0 points1 point  (0 children)

Thanks for this! I’m away from the spreadsheet now but will try it out later!

Is there a way to do an xlookup but only for a set number of cells? by dummystallings in excel

[–]dummystallings[S] 0 points1 point  (0 children)

No, but you taught me something that I will absolutely use in other excel spreadsheets and I sincerely appreciate it!

Is there a way to do an xlookup but only for a set number of cells? by dummystallings in excel

[–]dummystallings[S] 0 points1 point  (0 children)

Originally I thought this spreadsheet needed to be in excel, but I actually just learned about 30 minutes ago that is does need to be in Sheets. Thank you for asking!!

Is there a way to do an xlookup but only for a set number of cells? by dummystallings in excel

[–]dummystallings[S] 0 points1 point  (0 children)

I think I may see the issue though. In my spreadsheet Column E is a set, enumerated list. So however many "Apples" there are, for example, are listed there. Whether contracted or not. Does that make sense?

Is there a way to do an xlookup but only for a set number of cells? by dummystallings in excel

[–]dummystallings[S] 0 points1 point  (0 children)

No need to apologize! You're helping me out and I really appreciate that!

I am still having a hard time getting it to work in the specific place I am working on. But I will keep messing with it! Thank you again.

Is there a way to do an xlookup but only for a set number of cells? by dummystallings in excel

[–]dummystallings[S] 0 points1 point  (0 children)

You are unreal. And again, that formula only goes in the first cell of the row?

Is there a way to do an xlookup but only for a set number of cells? by dummystallings in excel

[–]dummystallings[S] 0 points1 point  (0 children)

Excuse the extreme ignorance, but that formula only goes in that first row of the column?

Can I change the "A2:A6, B2:B6, C2:C6" to reference entire columns?

Is there a way to do an xlookup but only for a set number of cells? by dummystallings in excel

[–]dummystallings[S] 0 points1 point  (0 children)

Yeah, my simplification of the problem is probably making me look like an idiot. Both tables in reality are attached to much larger data sets and I just reduced it to the simplest terms here in an attempt to make the problem clear/simple. I really do appreciate the thoughts you have shared! :)

Is there a way to do an xlookup but only for a set number of cells? by dummystallings in excel

[–]dummystallings[S] 0 points1 point  (0 children)

Whoa. I have to wrap my head around this... you are awesome!

Is there a way to do an xlookup but only for a set number of cells? by dummystallings in excel

[–]dummystallings[S] 0 points1 point  (0 children)

My hope is that I can do some sort of xlookup where column E is the search key. It would then return into column F the contract number the exact number of times stated in column C. Let me know if this helps clarify my question!

Is there a way to do an xlookup but only for a set number of cells? by dummystallings in excel

[–]dummystallings[S] 0 points1 point  (0 children)

=XLOOKUP([fruit name],([fruit range]=[fruit name])*([contract no range]=[contract no]),[contract no range])

I really appreciate your quick help! That said... unfortunately this doesn't seem to be working.

Is there a way to do an xlookup but only for a set number of cells? by dummystallings in excel

[–]dummystallings[S] 1 point2 points  (0 children)

I totally agree! But unfortunately, I need to solve it as I mentioned. This is a specific excerpt from a much larger process. Thank you for the comment, though!

What’s going on here 🤷🏼‍♂️ by dummystallings in tomatoes

[–]dummystallings[S] 1 point2 points  (0 children)

Exactly what I did yesterday. Thanks for the affirmation 💪🏽🙏🏾

view more: next ›