refers

Why is this formula returning 0 instead of the text that is contained in the cell it refers to? =VLOOKUP($K3,Sheet2!A$1:B$110,2,0) It does not happen in every cell it is in.

Hi I have found an array formula that allows me to select a list of details from a master list in excel based on 2 criteria and referencing a specif column. This array is very slow and time consuming. I have tried googling for something similar using vba but could not find anything similar. I...

I could use some help with this formula...

Hi all, Stumbled across this issue when trying to help someone else on here, Is it possible to name a range as a cell reference? My assumption is no this is not possible but worth an ask. E.g. I want to name the range N2:N3 as "h1" but that refers to a cell so it renders impossible right...

Good Morning, Ive tidied up all my table etc in the Name Manager but stuck on one. All my table are 1 column. So examples of my tables. Header Sold Name manager i see under refers to =Table22[SOLD] Range AK2:AK66 Header Bought Name manager i see under refers to =Table9[BOUGHT] Range T2:T100...

hello, i have created a dropdown list which i would like to link to another cell. the data from this cell will then allow a vlookup to operate in a 3rd cell. essentially: - M9 = dropdown list (1, 2, 3) - F6:F8 = cells that dropdown list refers to (a, b, c) - M13 = vlookup on F6:F8 i...

I am in the process of creating a spreadsheet that will be used to track the development of a new employee over a period of weeks, based on certain criteria that will be identical for each week of their development. From the base information, I have created other sheets in the workbook that...

I have a list of 200+ names that I want to turn into defined Named Ranges. They're in 2 simple text columns as shown in the image below. Is there code I can run that will generate these named ranges (the "!DBL" obv refers to a sheet named DBL that already exists in the file)? EDIT: FWIW, I want...

Hello Friends, I am trying to Vlookup from one workbook to another. Problem i am having is when i use a named range in the Vlookup - it works fine. But when a dynamic name range is used in Vlookup then its giving #REF! & to make the Vlookup formula work i have to open the mother source file...

Is there any way to check if any cell from a different excel file refers to a particular cell?

I have two workbooks. Workbook_A is a "shell" with the following named ranges and definitions: Name: Parameter_1, Refers To: Sheet1!$A$11 Name: Parameter_2, Refers To: Sheet1!$A$12 Name: Parameter_3, Refers To: Sheet1!$A$13 Workbook_B - which was originally based on the shell - has the...

Hi all, I've had a look through MrExcel (and other websites) and I'm struggling to adapt the answers found there to my problem. I currently have the following that refers to a single date (K2): =IF(SUMPRODUCT( -- ($J$2 = Data'!$Y$2:$Y$5000), -- (AF5=...

Hi guys, how is everything? I seek your help to assist me with the following I have a workbook called A, for example, it contains a dynamic hyperlink that I’ll control by some way Anyways, supposedly, that this hyperlink now refers to a named range in another workbook, this workbook is...

My file has several hundred Named Ranges ("NR") that I'm constantly using in formulas / changing. Whenever I want to edit something, I first need to look up just what cell range a particular NR refers to (so I can either change it, or edit the formula accordingly.) Currently I have to open the...

Hi, I have a userform with several textbox (Arrow1, Arrow2,........). When the form opens, the text box are populated from values in a worksheet: code is Private Sub Arow3_Change() On Error Resume Next Me.Arow2.RowSource = "" Me.Arow4 = Application.WorksheetFunction.VLookup(Me.Arow2...

HI, I have some cells in excel I would like to format as per the following typical entries I will be making 1 / A 1 / B etc... 1 / 1 / A 1 / 1 / B 1 / 1 / C etc... 1 / 1 / 1 A 1 / 1 / 1 B 1 / 1 / 1 C Etc. The numerical data is based on sections or subsections and there may be only one...