referencing

Good morning. I am working on an Index/Match formula referencing sheets in a folder. Trying to figure out how to reference a cell rather than have to type or do a search replace every time. Here is the formula =INDEX('C:\Users\jdoe\Desktop\2019 Budgets\[Derr2019.xlsm]Area...

Help! This formula referencing text within the same page, works perfectly in returning the first blank row number: {=min(if(indirect(“A”&J17):A26=“”,row(indirect(“A”&J17):A26),””))} However, similar formula below referencing another page returns #VALUE...

Take a look at the spreadsheet. The references will change after sorting and break the calculations. Absolute referencing is not an option. The table has to be copied periodically to another sheet and placed it at a different row (the columns are identical). Absolute referencing will break the...

<tbody> Level Name Industry ID Company Sector ID Sector Applicability ID Link Link Name Solution Name Prod 1 Prod 1 Rev Prod 2 Prod 2 Rev Prod 3 Prod 3 Rev Prod 4 Prod 4 Rev Prod 5 Prod 5 Rev Total Revenue by Row Revenue Split 1 Dairy Farms 43523 D43523 Dairy D43523Dairy (blank) 01-Dairy...

Is there any way to dump the text within a userform textbox straight into the line of code I need it for, without referencing some cell on the spreadsheet?

Hi, I needed some help writing VBA. I need to reference a range of cells one by one from sheet 1 (cells are in the range A2:A2357) to every 4th cell of column D in sheet 2, starting at D2. Please let me know how I can solve this. Thank you in advance for your help.

Greetings I've been searching for a way to create a Search Box to search my Workbook. I found some code on this site, and while, it does work, there are a few things I don't like about it. Here is the code I'm using (slightly edited from it's original): I'm using Excel 2016. Sub FindRadio()...

Hi Everyone, First time poster here although I've been referencing many posts from this forum for years. So much great info here. I'm trying to submit package info to the UPS site to automatically return the shipping rates. For a single package I'm able to do it. When trying to set up for...

Why does this formula return #REF ! when entered into a table where the formula is referencing cells outside of the table and inside of the table? =IF(H75="A", IF(Z75<S6,K75*Z75, IF(AND(Z75>(S6-1),Z75<(T6-1)),S75*Z75, IF(AND(Z75>(T6-1),Z75<(U6-1)),T75*Z75, IF(AND(Z75>(U6-1),Z75<(V6-1)),U75*Z75...

I have a table of data that is pulled from an external website via API. I am referencing one of the cells in the same workbook but different workpage, the data are all numbers. No matter which format I choose it will not change, for example one cell that I am referencing is 8000000000. I want it...

its late and i cant figure this out =IF(COUNTIF(INDIRECT(N$4),">0"),SUM(INDIRECT(N$3) ($B10)),"") gives me a #Ref error =IF(COUNTIF(INDIRECT(N$3),">0"),SUM(INDIRECT(N$3) ($B10)),"") gives me a #Value error =IFERROR(SUM(INDIRECT(P$3) INDIRECT($B12)),"") returns 0 (and i dont want 0 i...

I have a problem where I need to reference a cell in a matrix, and then I need to be able to copy both the reference cell and the matrix to a new destination (either a new spreadsheet or shuffle it around a few cells) but keep the relevant references in the matrix. So as an example (see image)...

Hi All, I have an unusual question I am really hoping you can all help me out. I have a "Master Spreadsheet" that references to multiple other spreadsheets and their specific cells. This is done by inputing the directory and the referencing cell (e.g A1) into the master spreadsheets cell. e.g...

I've been trying to use the COUNTIF function to extract the number of occurrences of a particular word CONTAINED in a bunch of cells by referencing an outside cell. It works fine if I enter the search parameters manually like this: =COUNTIF(B2:B443,"*wabigoon*") but instead of entering...

Hi, if you have Range(B2:B and lastrow) or (C2:C and lastrow) as the set range for example, Can the range be changed so it starts in cell 2 to lastrow but without referencing the column name or number. e.g. Range(2, lastrow) instead of cells(2, 2) or B2:B.

Hello, When I merge and try to drag that cell while referencing another cell, it would grab every other cell. So if i have 1, 2, 3, 4, 5,6 it would only give me 1,3, and 5. Is there a formula I can use ? Thank you in advance.

Hello, I would like to perform the following formula with 1802 being in cell B2, can anyone help please? Many thanks. =SUMIFS([1802.xlsx]REVENUE!$V:$V,[1802.xlsx]REVENUE!$K:$K,G6,[1802.xlsx]REVENUE!$E:$E,I4)

Hi, I need to have cell “A1” in my current worksheet linking to a particular cell in an external workbook, called for example Sample_workbook1.xlsx. Cell “B1” contains the location of this cell in string format. Eg...

I'm hoping someone here can answer this question. What I'm trying to do is set up a worksheet with product information (barcode number, item description, and unit price) to use as a databse and then set up a separate worksheet with invoice information (invoice number, product code, item...

Hello all! I'd like to use the formula below but with one modification. Where it says "tritanium=1211562705", I'd like to be able to remove the numbers there and have the formula pull the number from a specific cell. The formula...