google sheets

These are two example sheets of what I am trying to do: Reference: Reference Sheet Summary: Summary Sheet I am trying to pull information from the Reference sheet into the Summary sheet. I want to pull based on the zip code I enter into the Summary sheet, cell B2, from the row matching that...

Before I start, here's a copy of the sheets I'm using: Here's a copy of the sheet I'm using: https://docs.google.com/spreadsheets/d/1Y079euBk63RYcgFOPjBFwMlPi53SUAIgZ-h69_o9Hsc/edit?usp=sharing I have two sheets, Expenses and Tax Deductibles. The Expenses sheet has it's data filled via a Google...

I need some assistance with a formula for Google Sheets. The following formula works in Excel, but not in Google Sheets. I don’t believe the “Take” formula is in sheets. Any ideas on how to find what I’m looking for based on the example below? =TAKE(SORT(FILTER(C3:D10,B3:B10=G5),2),-1)

Hello, I am making a review list for some videos on google sheets, and can't get to an answer, why google sheets on some links gives the option to "fragment" and URL and for some does not. I don't even know if the word fragment is the correct translation of the word we use. I tried to ggole it...

In excel, I can create a table and find the first and last row of said table with functions like =min(row(table1)), =max(row(table1)). I'm trying to emulate the functionality in google sheets and I thought a named range would be the appropriate way for this. For first row, this works...

I am trying to use MATCH and INDEX to improve performance on a google sheet that has way too many XLOOKUP functions. I have a helper column (DH) that lists the matching ROW I need from the Visibility sheet. This formula returns the expected result from column 9 on the Visibility sheet, where...

How to return the "Ship From" in Cell B2 based from the data in another tab with a substring criteria in Col A (currently listed in Col E/F)

Hello, What should be the formula to use in C3 in order to look up for the last non-blank above A3? In Col D is the desired result

Can someone please fix this Google Sheet for me? I need it desperately for work. I cannot figure out what I'm doing wrong, and every formula I've looked up doesn't work for me. It's driving me CRAZY! o_O I've highlighted the columns that are giving me issues in yellow (sheet linked at bottom of...

This question is for Google Sheets. I'm asking two questions in one post, both are related to the same thing. Is there a way we can use formulas like in the picture below, to achieve the results, instead of hardcoding the ranges in the charts setup? It is also crossposted here, no answers so...

Hi all, I'm trying to work on this last bit of my Weekly Meal Planner. I have multiple sheets within this one document and it would be easiest if I gave the link to the document itself rather than posting an image. Weekly Meal Planner In the sheet labeled Grocery List, in the fourth column I...

I have a Macro that is activated by a button in my Sheets. It does exactly what I want it to do separated, but when I tried to combine both functions (Autofill & Sort), it doesn't finish the sort. My guess is that it is doing it all simultaneously so it's sorting before the autofill calculation...

I'm trying to assist my daughter who has asked me how to get raw data categorized by category and month. Here's a sample. Given: Given a long list of data with about 35 categories in columns A-C, how do I get a monthly table like on the right side? Thanks in advance.

Hi, I am working with a spreadsheet that is heavily formula driven and I have a feeling that what I am about to ask is impossible. So currently we are working with GSheets on this. So the formula that I really would like resolved is multi layered. In this example I will use 5 sheets (however...

I have an Excel file. In which I put some VBA. But I need to do the same in the google sheets. But I need to convert the VBA to appscipt. The Excel file link is below. What will be the appscript code? Please help me. Excel File

Hi, The following formula works in excel but not in Google Sheets. How do I modify to work in Google Sheets: =LOOKUP(REPT("z",255),CHOOSE({1,2,3},"", LOOKUP(999999999999999,SEARCH(abbreviations!$A$1:$JZ$1,'Invoice Insert'!F110),abbreviations!$A$3:$JZ$3))) I basically want to search a range...

Hi, I have a list of bookings from accounts and would like to select a month, year, and account name (B2, B3, B4) and see the total revenue from that account for the selected month/year in D2. What is the best way to go about this? Sample spreadsheet link: Test Spreadsheet

Using Google Sheets. Column A contains a list of products. That list is imported from outside Google Sheets (Shopify). The list constantly changes as new products get added or removed. When products are added they don't necessarily get added to the bottom, they get added anywhere on the list so...

Hello everyone, I am sharing this shared sheet with you in order to find a function/script to add as follow: Whenever a user makes a change in the column J, his email/name will be written in relative column K. here's the google sheet MySheet

Hello, We have a list of data that has multiple entries, but many of them have the same member ID. The data in every row is different; only the member ID is common. We have created different Google Sheets for members, and when we add the data with the member ID to the main sheet, it should...