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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back