refers

  1. R

    V Lookup Error

    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.
  2. M

    extract-all-rows-from-a-range-that-meet-criteria-in-one-column-in-excel using vba

    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...
  3. J

    Formula will not automatically adjust when adding/removing rows?

    I could use some help with this formula...
  4. tyija1995

    Named Range Query

    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...
  5. I

    Table question please

    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...
  6. D

    link a dropdown list to another cell

    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...
  7. J

    Cell References not updating when a row is added/removed

    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...
  8. D

    Generating Named Ranges from 2 text columns (Name and Refers To:)

    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...
  9. H

    Vlookup Not Working with Dynamic Named Range

    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...
  10. J

    Is there any way to check if external spreadsheets refer to cell?

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

    Copy named range contents and range definition from one workbook to another

    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...
  12. A

    SUMPRODUCT for range of dates

    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=...
  13. M

    VBA to Copy and Paste

    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...
  14. D

    How can I view / edit Named Ranges without going through tedious Name Manager window?

    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...
  15. D

    Vba code for manual input on text box

    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...
  16. T

    Custom Number Formats

    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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top