dget

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

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

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

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

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

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

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

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!

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

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

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

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

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