multiple columns

Please help. Cant get index and match to work :( <tbody> </tbody> <tbody> Location Old Code New Code A AVR =INDEX(Table2,MATCH([@Old Code],Table2[#All],0),8) N VVB G XX W YY p 9S C RCM1M T H </tbody> Table 2: <tbody> A N G W P C T New Code ABB PPS 2PL AB APB...

Hi all-- I have an extensive formula that works well, until I filter the results. Hope someone can give me some assistance in shortening the formula (if possible) as well as getting the filtered results. Here is a sample of the formula that I am currently using...

Hi Folks, I want to be able to get a sum for a column using multiple criteria in at least two other columns. I don't have a problem when using multiple criteria in only one problem, but I can't find a way to have multiple criteria in multiple columns. An example follows: Product Supplier...

I have a list of values on another sheet that I want to try and match to two columns (there are multiple lists to match to different sets of columns so something easy to repeat would be great). If one of the values in the given list (changeable) matches a value in the columns, the whole row...

Trying to solve this. What I want: Formula in column D saying Yes or No based on following rules: If a cell in Col. B equals "Bob", then look everywhere in Col. A with the same content, for ex "A1", and if in Col C there is "17", then put "Yes" in D on same row as Bob. Otherwise, "No", as...

I need help with excel sum calculating! I have a table with 4 Amount Fields and 4 Date Fields I need to Calculate sum from all amount columns which are in particular month and get a result like this: January 2016 - Total Sum January 2017 - Total Sum etc... I already try this...

Hello All, I thought I'd nailed this but I think I'm well off the mark. I've two columns, one with dates and one with times, side by side, they'll be entered by humans and so keeping date and time separate is essential to avoid a **** up from the beginning. I then have a cell with a single cell...

Hello All, Thanks in advance for any help you can give me. I need to extract a unique list of names from two columns of names, but only names that fall within a given date range. I would also like for the extracted list to be sorted alphabetically a-z. The datasheet is a list of "deals" for...

Hello, first time user here! I am trying to calculate total sales for each line item in Sheet 2 from the information given in Sheet 1. For example, Line 1 (Car WK1), should have total sales of 35. I'm having trouble figuring out how to sum multiple columns with the same header by using sumifs...

<tbody> I'm looking to sum totals in a drop down list as follows:In column C (lines 7 - 38) I have a drop down list that assigns categories to that particular line. In column F (lines 7 - 38) there are totals that apply to that particular line item that are numbers. These totals change with each...

I am trying to use a listbox with multiple columns to add data to a worksheet. Because this listbox has about 1000 entries, I need a search box filter to help me quickly find the data. I have found some code here that will filter the listbox as long as it is for a singe column and it is case...

Hello, I'm trying to build an array formula that will return the value, based on matching criteria from 2 columns within that spreadsheet. Here is an example of the data, and what I've pieced together so far that is returning an #N/A: <tbody> A B C D E F G H I J K L M N O P Q 1...

I have a sheet whose data looks like this (only much larger, of course): Account# JanAmount Account# FebAmount Account# MarAmount 132441 $36.28 12444 $249.45 143144 $223.10 144314 $97.19 143144 $283.29 41343 $278.80 12444 $68.82...

I don't do things by halves so here is a notty problem I have and cannot resolve I am picking up data from a sale sheet and where the vendor number matches the vendor in the sale sheet I am returning the lot, description and Sale value. Now when I get to the bottom of my "form" which is about...

Hi Folks, I need assistance with eliminating duplicates occurring in multiple columns in a worksheet. An example if the worksheet is as follows: <tbody> 1 10 20 2 11 21 3 12 22 4 13 23 5 14 24 6 15 25 7 16 26 8 17 27 9 18 28 10 19 29 11 20...

I've searched the stickies and FAQs and haven't found anything -- after 20+ hours of dedicated research I HAVE to ask you folks how to do this... Initially, I was searching for a formula to set the format of Cell H3 if Cell C3 contains "0 - Completed" as a text string. Then if C4 contained "0...

I'm completely befuddled on what seems like it should be an incredibly easy macro. (Only been working with excel a few days, so please don't hate me because I don't know what Im doing yet.) I'm getting different worksheets in that I plug in formulas across a few rows and then pull them down to...

I am doing a research project on the scriptures that involves me listing certain verses with their chapter numbers. My idea is to make one column where each verse and chapter I am referencing will be in this format ---> For example: chapter 5 verse 2 = 5.2. I formatted all cells in my column as...

Hi all, I need to be able to sum multiple columns based on the column header (to select the columns) but also particular rows based on the first column. Please see the below example: <tbody> Basic Allowance Basic Tax Basic Emp No. Salary Accom Hol Pay Tax Temp Sal 1 5000 1250 850 500...

Hey guys, I am a little confused on creating a macro that can loop through 2 columns Column B and Column C Column B would be (-0209,-0600,-0900,-0920,-0930, or -M150) Column C would be (-0201,-0202A,-0202B,-1010,-0115,-0610,-0940,-0150, or -C150) if none of these were found in the row...