1. B

    Dynamically changing array elements in a formula

    How can I create an array in a formula which while filling down the items of the array change in a specific manner. What I want is in cell B15, while in a function like say dget where there is an array field part in the formula, the contents of the array will be A14 and A15 i.e. {"Customer...
  2. N

    DGET fxn with nested TODAY fxn error

    Hello everyone. I have a specific goal I am trying to achieve and I'm hoping you can help me. My Goal: I am using a basic loan amortization schedule spreadsheet to tract a loan. I want to add a dynamic cell that displays the current balance of the loan based on the current month. My...
  3. B

    Multiple DGET use in one sheet

    Hi, I have a workbook with 2 sheets. One is a database sent to me that contains BRANCH CODE and BRANCH columns: The other is the sheet that I'll actually be working on: So what I want to do is when I key in the number on the SITE COD columns, the SITE NAME column automatically gives me the...
  4. A

    how to display pictures on excel worksheet using dget

    Hello All, Iam using dget function to extract data. When trying to extract picturs/symbols from database #value ! error is encountered. How to extract pictures from one sheet to other sheet using dget function ? Attaching below screen shots of two sheets. 1.Above is database of sheet 1. I...
  5. A

    Limit Range of INDEX/MATCH based on a Condition

    Hello I have found many posts that come close to solving my problem but I cant quite crack the answer. I have a data range that looks like this: <TABLE style="WIDTH: 488pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=651><COLGROUP><COL style="WIDTH: 136pt...
  6. R

    Vlookup function quandry

    I am new to forums so be kind. I fancy myself more than a beginner with Excel but reading some of the post I have no clue what some of you are saying. I am tracking inventory shipments and have to report what shipments have rejects. I have a data table with a listing of all part numbers shipped...
  7. S

    Lookup help

    I need to find the location number that fits into the ranges in the table on the right from the table on the left. I tried a DGET and I am getting no where fast. Any and all help would be greatly appreciated. My sample data is shown below: <TABLE style="WIDTH: 550pt; BORDER-COLLAPSE: collapse"...
  8. H

    Name Range linked to multiple worksheets?

    DELETE THREAD, I feel like an idiot, I figured it out....! But see, this is why I figured it out, had to post something about it first, LOL SORRY Message board!
  9. W

    Return first record of a dget when there are multiple answers available

    Hi, I am tring to get the first value of a dget when there are multiple answers available... Example Database = timestamp and value find the minimum value =dmin(database,"value","value_setup") This will return 0.6151... Now how do you find the first value in the timestamp column based on...
  10. G

    Referencing Problem

    Hi there, If anyone could help, it would be great. I have a sheet which contains performance and potential scores, and the person's name & surname which corresponds to that score. In Column A is the performance score, and in Column B is the Potential score, with Column C containing the Name &...
  11. M

    Is there ever a time when DGET isn't rubbish?

    Hi A question I've been pondering over that someone might have a decent answer to. There are so many different ways of extracting data from tables/databases - INDEX/MATCH, VLOOKUP, Advanced Filter, Array Formulae, ADO Recordsets, Microsoft Query to name just a few. Then there's DGET - in...
  12. A

    Table Interpolation Any Ideas? (tried over 20 formulas with no sucess)

    I have attempted several formulas with no sucess. The goal is enter ALT and TAS data into the E,F <DUAL INPUT Reference>. (See line 1. below) IF(E1s value <= $A$1:$A$15 values = TRUE, THEN F1 = E1 AND F1s VALUE MATCHES <= $B$4:$B6 VALUES THEN RETURN LBS = 3.5 Any Ideas? <Look Up Info>...
  13. D

    Link to an image

    I'm using a DGET formula to bring up data about pupils. When I type a name into a cell the formula returns data from another sheet regarding their performance. What I'm trying to do is bring up an image of each pupil with the data. I've tried everything I can think of. Is there any way of...

Some videos you may like

This Week's Hot Topics