multiple

Hello I'm new to the forum and look forward to your insights I have the weight band in column D and want to look up the prices in columns E to J how do I return the right price for each row? See below <tbody> Weight (lbs) Weight Band A B C D E F 167 A 156.53 126.79 107.98 90.78 78.94...

Hi Guys I have 3 columns A2:C10 where i put an Id in ie 12345 now some cells could have blanks, an Id or multiple Ids separated by a comma what i want to be able to do is if the cell has an id or multiple ids then create a string like this <found> for some reason its lost my string concat it...

I need to review a list of data and return all of the matches based on 2 criteria and cannot figure out the entire formula. Below is what I have now but it only matches 1 criteria: "CASH IN IMPORT'!$R$5. How on earth do I add a second criteria, which would be column B of sheet '3.INT' matching...

Hi - I have this code to copy rows to another sheet. I thought I could extend the range by add this code. But no, any suggestions on how I include the extra columns in the copy range? Tried this ws1.Range((ws1.Cells(thisRowA, "B"), ws1.Cells(thisRowA, "H")), (ws1.Cells(thisRowA, "K")...

I have never attempted this before. But, is there a way to place your Access DB on SharePoint, but have it linked to where it saved in the folder its linked to? Also, multiple users should be able to open it correct?

How can I write a formula that will sum the value from multiple columns using an index match matrix based approach? The formula below will work when there is only one column that has the "OC_TECH" value, but I want to sum both values if "OC_TECH" occurs as a column header more than once. for...

Hi Guys, i just completed my registration as I guess you are playing the Championsleague of Excel, so I think it is the best place for a special question. Think about a workbook having 2 sheets, the first sheet has multiple lines meaning multiple records with the same structure. The columns...

Hello I would like a macro that works through a long worksheet, set up as follows: Column A: product code (3-digit code) Column B: notes about product (free text - can span multiple rows due to character limits) Column A is blank in the rows where the data in column B has spilled onto...

I have a worksheet called Data. Each row relates to a customer repair. In column C is a part number (3 digit). There are many different part numbers distributed on different rows. If the customer rings to chase the repair the user puts an X in column S against that customer, so there can be...

Hi - i'm using the code below to show open workbooks which the user can then select one. How do I update the code to allow the user to select multiple workbooks and how do I name them? Code in a Module Dim WB As Workbook For Each WB In Workbooks UserForm5.ListBox1.AddItem WB.Name...

i am hoping someone can help me with an IF formula that has multiple conditions. I have tried a few different ways but still I cannot get it to work. What I require is if A2="0" then return a blank if L2 ="0" then return a blank If A2>L2 return "Late" If A2 is <=L2 then return "on time"...

I need to sum deposits for each account number for deposits that have valid codes. I've tried SUMIFS and SUMPRODUCT, and run into the same problem of setting criteria to a range of values (E2:E6). Here is where i'm at from a SUMPRODUCT path: =SUMPRODUCT(--($A:$A=$G2),--($C:$C=$E$2:$E$6),$B:$B)...

I am trying to copy the following formula that has multiple If Statements referencing multiple other cells for the desired results and only the first cell referenced but not the follow 3 cells referenced in the desired results. =IF(A2=1,'Team 1'!B13,IF(A2=2,'Team 2'!B13,IF(A2=3,'Team 3'!B13...

Hello, Is it possible for a VLOOKUP to have a multiple lookup value. For example: =VLOOKUP(A1,'Data'!$A$1:$D$1000,2,FALSE) If the lookup value in A1 is empty it can look at a different lookup value in A2? Thanks in advance, Chris

Hi Does anyone know how i can return multiple column using VLOOKUP in a new workbook? I have tried this off the net but it won't work. =VLOOKUP(A3,[Parks and Leisure Sites.xlsx]Sheet1'!$A:$F,{2,3,4,5},FALSE) Thanks Ernie

Good morning everyone, I hope someone can helps with this one, I have the following formula(copied down through rows etc) =IF(D2=G2,"ok",IF(D2>G2,"Supplier MPQ higher","Check pack multiple")) to return a simple text answer, but what I wish to modify this (if possible) to show that t if G2 is...

So, I have a several locations. Lets say Phoenix, Goodyear, Avondale. For each location, they could have a number; 1, 2, 3, 4, or 5. Keep in mind, the location and numbers can be listed multiple times on this sheet. So what I need is, for the Location of Phoenix, what is the total amount for...

Hi I want to add time then multiple the result by rate which is 10. So I have my time formatted as hh:mm then I used =Sum(B1:B4) to find the total which is 21:00 Now I want to multiple 21:00 by 10 to find how much to pay I got 18:00, clearly that is wrong. So I convert the total pay cell to...

I cant seem to get my head around SUMIFS and VLOOKUP, Im currently using: =SUMIF('Gas July'!$B$2:$D$217, VLOOKUP($A3, 'Gas July'!$B$2:$D$217, 1, FALSE), 'Gas July'!$D$2:$D$217) Which points to a sheet with only July Data and multiple sites and it gives me the number I want (total usage for...

Not even sure if this is possible. I have a workbook with 31 sheet and want to st up an extra sheet that pulls all the data from A22 to h42 into a list to look like 1st A22 B22 C22 E22 F22 G22 H22 1st A23 B23 C23 E23 F23 G23 H23 and then so on that I can then drag to change the "1st" to...