pulling

I have a form that updates some records by pulling fata from 2 other tables. The first event worked with no issue pulling the brand from the "Items" table (It looks for the "ItemID" to match the records: Private Sub ItemID_AfterUpdate() Me![Brand] = DLookup("Brand", "Items", "[ItemID] = " &...

Hi There, I have an google pulldown menu that works fine, but when I select an other cell I keeps pulling down? hereby my code, what am I doing wrong? Private Sub ComboBox_Change() ComboBox.DropDown If Range("B5").Value <> "" Then Range("B6").Value = Evaluate("=VLookup(B5,SEARCH, 7...

Hi everyone, My VLOOKUP seems to be pulling the wrong information. =VLOOKUP(AE1,'Study Database'!B9:AN6000,9) Where; AE1 = Dave I was expecting the lookup to find Dave in the database which covers B9:AN6000 and pull the information on row 9 from the line which has Dave's information. Instead...

HI! I am using a vlookup/match to populate fields from column headers. For the most part it's doing exactly what I need except instead of pulling column 2 twice and not pulling column 7. code I am using: =VLOOKUP($A$10,$A$2:$G$6,MATCH(B9,A1:G1,0)0) I copied the code across the columns it...

I am looking to create a formula where on the top row, I have dates for each day of the week from 10/1/17 through 9/30/18. In the first Column, I have Service Areas. My data is different counts. In one data set, I am pulling just counting numbers. In another set, I am pulling a percentage...

I have a pivot table that is pulling data from another table. From the table that Iam pulling the data from there are a few columns. How do I get the percentage profit in the new pivot table Column if the table that Iam pulling the data from doesn't have a column that shows the percentage...

Hello, I am trying to perform a VLOOKUP. It is successfully pulling most of the information, but sometimes it just skips over a value without pulling the number from the data array. I have tried messing with the formatting of the cell and checked for leading and trailing spaces. Any idea why...

I have the following formula that works when both workbooks are open, but not when the one I'm pulling from is closed. This is a report for another team that won't be opening the workbook I'm pulling from. I've read to use SUMPRODUCT for closed workbooks, but struggling on writing it correctly...

I have a userform which has some comboboxes. On initialize, the comboboxes' drop down lists are populated with a literal 2d array. Later in the initialize code I pull information from various sheets into the userform (info from previous contacts). The reason for the 2d array is that a few...

I have been working on a spreadsheet for a while and I am getting an error on one of my macros. "Can't do that to a merged cell". I do not have any merged cells. Is there any way for me to attach a file so someone can help me figure this out? I'm sure it is something simple, but I am pulling...

Hi All I have spent fruitless hours on something that I am pretty sure should be straightforward, please help my sanity :confused::confused: <tbody> 1 AJ AK AN 2 Date expected Overdue? Submitted 3 05/05/2018 07/05/2018 4 16/07/2018 #/N/A 5 05/09/2017 #N/A </tbody> So, I want the...

I have used the Index formula to pull information from another sheet within the same workbook, but it does not work properly. The 2 sheets are identical, and should populate the relevant information, but it isn't. Formula: =IFERROR(INDEX(Outstanding!I:I,MATCH(J2,Outstanding!J:J,0)),"") I am...

Hello, I'm trying to best copy and paste an array formula to a new tab. <tbody> =INDEX(BackData!$A$1:$G$2155,MATCH(Rep1!$A$2&Rep1!A6,BackData!$D$1:$D$2155&BackData!$B$1:$B$2155,0),3) However, when I copy it the formula to the Tab for "Rep2", the formula stays with "Rep1". I want the...

Hi all, have a question which I don't think is possible. can the vlookup I have in place be adapted to pull cell colours in as well as the data in the cell without the need for conditional formatting? as far as my knowledge goes excel isn't capable of pulling if cell formats only the data in...

Hi There, My interactive combo box keeps on pulling down when I select an other pull-down menu. what value do I have to put into my VBA writings??? that it will not pulling down automatically see below for combo box value Private Sub ComboBox1_Change() ComboBox1.DropDown If...

I am currently working with a list of 20K plus names. Each name has a "supervisor name" associated with it. However, I am trying to utilize this formula to show all people under specific supervisors when one is listed...

So I'm trying to pull data from a set. The info I need is the numbers around a decimal. <tbody> Have Need Intel Core 2.14 GHz 2.14 AMD Core 1.99 GHz 1.99 Intel Pentium 2.56 GHz 2.56 </tbody> I have been using the formula =MID(A1,FIND(".",A1,1),3) so I can get the numbers after the...

Hi all, i'm usually good with formulas but this ones got me crazy, i'm trying to add up a bill because i think my network provider is pulling a fast one: I'm trying to add a these sort of formats: http://imgur.com/a/U2FyN Thanks for your help guys!

Hi, I am having an issue with my pivot table listed a piece of data I can not locate in the file anywhere. I have verified the Data Range that the pivot is pulling from, and can see exactly where the amount it calculating is, however the header label is adding a digit to an account number...

Hi, Is there a formula for pulling images into excel? The images are either in another excel spreadsheet (ie. I could do a vlookup, but to pull the image in) or the images are located in a particular folder. Thank you.