Find Matches In Multiple Columns And Return Header

Oct 29, 2012

Lets see if I can put this into words.

I am trying to find matches of a specific cell in various columns. Example:

Header 1 -------Header 2----------Header 3
-ABC123-----------abc123--------------abd123
-abd123-----------hjk321---------------hdn234
-Abc123-----------dsd123--------------sds332

If I searched for the value "abc123" I want it to return Headers 1 and 2 in a seperate column. It would not matter if the same value is in one column multiple times

So the results would show me the Column Heading for anything that reads: "abc123", "ABC123", "AbC123", "aBC123"

Is this possible?

View 2 Replies


ADVERTISEMENT

Find Min Value In Multiple Columns And Match The Header

Jun 1, 2007

I am trying to find min value for a row (product price) within two columns (price lists) and return row one (company name) in third column ( see the attachmet). My first idea was to use “min” and “if” but a problem occur when there are text or zero or none values in the price list. I tried with conditional formatting, offset function, match-index and other methods without success

View 4 Replies View Related

Find Duplicates From Multiple Columns And Return A Value?

Jun 9, 2014

My spreadsheet has multiple "sessions" by date and each has three columns: a name, their organization, and a column where we want to display an "R" if they are a repeat participant. Each new session is entered to the right of the last. The names are in every third column. Like so:

name company R
name company
name company
name company R

Is it possible to search through the whole document to find repeating names, and then display an "R" in every third column if they are a repeat participant?

View 4 Replies View Related

Find X In The Corresponding Row And Return The Header Value

Apr 28, 2009

I need a formula to put into cell B19 to Find X in the corresponding row and to return the header value

******** ******************** ************************************************************************>Microsoft Excel - Book2___Running: 11.0 : OS = Windows .NET Server (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA1=ABCDEF1Part NumberDescriptionSubframe BuildCut And ChopHopper BuildCabBuild2026319Assy Air Ram Auto Blanking  X 3026321Assy Air Ram Rear Boom L/H  X 4026320Assy Air Ram Rear Boom R/H  X 5022587Assy Air Ram Side BrushX   6031159Assy Air Ram Side Brush Large DiameterX   7030501Assy Blanking Flap Valve Single Vm Minor    8034783Assy Brake Pedal Lh Vm Minor Fl   X9034784Assy Brake Pedal Rh Vm Minor FlX   10036349Assy Brush Control D/S No Hp Opt Mer/Mag X  11024553Assy Brush Core 1300 Large Widesweep X  12024554Assy Brush Core 1300 Small Widesweep X  13023169Assy Brush Core Large 7000 X  14025662Assy Brush Core Large 80/85 X  15032482Assy Brush Core Magnum Poly/Wire Mix X  16      17      18      19034784Subframe Build    20023169Cut And Chop    Sheet1 [HtmlMaker 2.41] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

View 9 Replies View Related

Formula To Find Matches And Return Yes Or No

Jun 11, 2014

In the attached sample work book Col E has text that I want to check if it is also in Col G and return Yes or No into Col F

View 4 Replies View Related

Compare 2 Columns And Return Matches

Aug 12, 2008

I have two columns, one with the target text (D:D) and one with text I want to compare it too (A:A). If the text in column (D:D) matches the one in (A:A), I want to return the value in (B:B). I attached a sample of the problem i'm dealing with.

View 5 Replies View Related

Find Last Entry In Row And Return Column Header?

Aug 1, 2014

I've got a spreadsheet with various amounts in cells A3:L5. I want to find the last non-blank entry in each row but only where the entry is in a column headed "Guaranteed PRB" (found in row 1). Then I want it to return the column header title found in row 2, which is a date.

I've attached a sample of the spreadsheet with the expected answer in column M.

I've got as far as formula:

=LOOKUP(2,1/(a3:l3<>""),$a$2:$l$2)

how to also make it look at row 1's headers too.

View 5 Replies View Related

Find Value In Table & Return Column / Row Header

Nov 23, 2009

I am having trouble with getting a value (which is the row and column value) from a set of numbers. I have attached an example table to try and make things clearer.
What I have is a table with a set of Row Headers, and Columns Headers all numeric. e.g Columns headed 1, 2, 3, 4, Rows 30, 40, 50 etc. I want to find the 1st occurrence of a value e.g. 1.0 in the table (by 1st Up mean closest to top left), and then give me the value of the Row and Column Header that corresponds to that.

So for the example attached, I want to get the row Value 200 and Column 6 from finding the 1st occurrence of the number 1. I have tried various combinations of index and Match etc. But I can't get my head around the fact that the position of the 1st no. 1.0 can change, therefore I can't use any releative positions etc.

View 3 Replies View Related

Find First Non Blank Cell In Row Then Return Column Header?

Jan 17, 2014

I have this table, which can be seen as a basic custom gantt chart: KLRWo.png

And I would like to fill the A column with start dates, based on the first filled cell of the range on the same row, and the header value of its respective column (row 1). It's easier to show my expected result than write it actually:

WiMZH.png

View 6 Replies View Related

Find Cells That Contain Special Character In Given Row - Return Corresponding Header(s)

Jul 21, 2014

I'm looking for a VBA Macro that will do the following:

1. Count number of cells in a given row that contain special character "*"
2. If there is an asterisk in a given row, return the column header(s) contained in row 1 of the spreadsheet that correspond to each instance of cell(s) that contains the "*".

Is there a way to do this? I've attached an example of what I'm talking about, (Column A shows the desired result.)

Formula Question.xlsx

View 2 Replies View Related

Compare Columns On Different Sheets, Return Matches To Third Sheet

Mar 21, 2007

I've got two worksheets ("June" & "July"). On both worksheets, column A is comprised of ID numbers and column B contains dollar amounts. I need to compare the ID numbers in Column A on each worksheet, and if they match I want to copy the ID number and the amount to a third worksheet ("Results").

View 3 Replies View Related

Find Matches In Columns

Oct 27, 2008

I have two lists of email addresses in columns and I need to find the matches between columns and have those addresses returned to perhaps a third column.

View 2 Replies View Related

Find Sub String Matches Between Two Columns?

May 30, 2014

I am trying to match words in two separate columns that are not exact matches. any formulas or codes I can write to do this.Below is an example.

Column A
3m Corporation
Apple Inc
Allstate Corp
State Farm

View 2 Replies View Related

Excel 2007 :: Match Data In Two Columns And Return Header

Apr 20, 2012

I have two columns with team abbreviations, one simply says whether they are AL or NL the other is the result of a search with multiple occurrences of the team name. I need to match the long list with the short and put the column header AL or NL in the adjacent cell.

I'm using Excel 2007

The last formula I tried was =INDEX($AY$1,MATCH(BB2,$AY$2:$AY$15,0),0)

The screen shot actually just part of the sheet copied since the screen shot look like a broken html page Ok I give up. I copy and paste a jpg it turns into code, I copy and paste the spreadsheet and formatting vanishes, I don't have a URL for the picture... I did look at FAQs and didn't find picture rules but I will look again. Meanwhile. . .

It's just six columns of data. The short list is in AY from AY2 : AY15
The long list is in BB from BB2:BB505
The column header "AL" is in AY1 and NL is in AZ1

View 2 Replies View Related

How To Find Matches Between Two Columns And Copy Cells In Row

Jan 15, 2013

I've just started with VBA and are trying to figure out following:

I'm using a validation list where the user choose one of twelve alternatives. The option she or he made is found in one or more rows in column B. If there is a match between the alternative in the validation list and in column B I want to copy some of the cells in the same row as the match in column B (to be exact, I want to copy the cells in column E, J, N and P) to another sheet.

I've succeeded doing this with one row but I don't know how to do without using that same code over and over again until Excel has made it trough all the rows. And there is over 200 of them.

View 2 Replies View Related

Lookup Function Required To Return Multiple Matches

Apr 24, 2007

I have a list with 8 columns. In the majority of instances, Columns A & B will have duplicate information. I need to be able to search columns A & B & return the information from them PLUS all info contained on the same row's from columns C/D/E/F/G & H. EG:...

My column headings are as follows...
Type Region Contact Phone Email ADD1 ADD2 ADD3

In column A (type) would be the type of contact eg:business/personal/family etc.

So... If looking for family I'd need excel to show me the region, contact, phone, email, add1, add2 & add3 for each family record. Hope this makes sense!
There are over 1000 records i need excel to search through & return matches.

I'm an intermediate excel user at best so finding it complicated. Tried vlookup but that stops when it finds a match & anything else seems over my head.

View 9 Replies View Related

VBA / Find Column Header And Reformat (date) Values In Columns

Jun 28, 2013

I have VBA code to perform some actions on data in excel file and then convert all that data into semi-colon separated CSV/text file (code below).

Now, all I want is to add VBA code in the existing macro to find a column header (say, "Application date") and then convert all the dates into YYYY-MM-DD format. The original values in this column don't have a fixed date format.

Code:
Public Sub ExportToCsvFile(FName As String, _
Sep As String, SelectionOnly As Boolean, _
AppendDataOnExistingFile As Boolean)
Dim WholeLine As String Dim FNum As Integer
Dim RowNdx As Long Dim ColNdx As Integer

[code]....

View 3 Replies View Related

Cross Check 2 Ranges For Matches & Return Row Number Of Matches

Apr 29, 2009

I have several worksheets (Labeled Sheet1,Sheet2,sheet3) What I need to do is to step through each row in sheet3, and do a search in sheet1, it the data was found, then return the row number. I then will need to copy data from sheet1 (rowfound columnA , through rowfound CoulmnBd to sheet3 current working row columnK

View 3 Replies View Related

Return Matches & Non-Matches From Delimited Cells Against List Range

Jan 29, 2010

In my spreadsheet, on the first worksheet called "Working". Column A, called "Results", contains carrot ^ delineated string values in each cell (i.e."john^apple^pear^banana^grape^love^heart^pickle"). The majority of string values in every cell in my "Results" column match a "source" column of Pick-List Values, called "Fruits" in the same spreadsheet, however found in a different worksheet called "Lists" (also in Column A). I want to perform 3 functions against my "Results" Column on worksheet "Working":

1.) Report In Column B: Analyze column "Results" by cell and return carrot delineated string values for only those that match my "Fruits" Pick-List

2.) Report In Column C: Analyze column "Results" by cell and return carrot delineated string values for only those do not match my "Fruits" Pick-List

3.) Report In Column D: Identify and return all unique values in "Column C" as a List.

Attached is a simple example of what I'm trying to accomplish called " Sorting.xls"

View 4 Replies View Related

Compare Multiple Columns & Copy Matches

Dec 2, 2007

I am trying to compare mutiple columns of data, match them and copy select data. Find matching cells in 2 different columns and copy select info into that row. See file attached

View 7 Replies View Related

Possible To Sort Hoizontally With Multiple Columns Under One Header

Aug 6, 2008

In row 1 I want to have the names of servers, so we would have A C D E

Under each of those I want to have 4 other columns, so A would have on row 2 Start, End, Data, Time, or something like that.

Then B would have under it Start, End, Data, Time

And so on for C D ...

I would then want to sort it by the top level row, so if I had to insert B at the end I could sort it so it would be

A B C D E with all of the Start End Data and Time for the server to be moved along with it's master header.

I tried setting this up but then I went to sort it told me it could only sort if the columns were the same size, so having a merged top level A with four things under it did not work.

View 9 Replies View Related

Return Column Header If Row Header And Value Is Known

Nov 18, 2011

I've been trying find an appropriate formula to extract the column header from a table in a different sheet if the row header and value in that table is known.

in the lookup table the row titles (column A) are product codes, column titles (row 2, D through AX) are business names and the table values are quantity.

In a different table I have product codes in column A and in column B i have the max number/quantity of products for that code. In column C i want to put the company name associated with the product and the number/quantity.

View 4 Replies View Related

Cell Return All Matches From A List And Have The List Of Matches Reduce As You Type

Jan 28, 2009

is it possible to have a cell return all matches from a list and have the list of matches reduce as you type, then be able to select one item from the list? this is a typical feature on internet sites, but can it be done in Excel?

View 3 Replies View Related

Return A Count From Multiple Columns - Each Column Has Multiple Answers

Sep 28, 2012

Want a single count of multiple columns based on the columns selected value. Data is in text format.

Have tried multiple COUNTIF statements and have tried using pivot table (Excel 2010) both only give me total counts for all. I think I need an OR statement somewhere, but not sure where?

In other words, if a single record has an "any" in the any fields or a "yes" in the yes fields, I want to to count that as one record.

Sample data:

Pegnancy Smoke
Pregnancy Alcohol
Pregnancy Marijuana
Pregnancy Powder
Stress Cigarettes
Stress Marijuana
Stress Alcohol
Stress Medication

[Code] .....

View 2 Replies View Related

Find Values In 2 Columns And Return A Value In A 3rd Column

Jan 30, 2008

I have 2 spreadsheets, I need to collect the data onto 'figures 07' from column D on 'spreadsheet 07' by date, based on the name matching. ie cell B4 on 'figures 07' should be 166 and cell C4 should be 72. I've tried IF and LOOKUP but they don't give me the correct answer Auto Merged Post;Here is the second spreadsheet, it wouldn't let me attach both of them on my first message

View 4 Replies View Related

Find Data In Column Range & Return Cell Same Row But X Columns To Right

Jun 18, 2008

i have is 3 sheets in the same excel document. Sheet 1 is the mater sheet, which is a compilation of sheets 2 and 3, however the sheet layouts are different.

The sheets consist of a list of names and details. Sheet 1 has all the names in the list, however sheet 2 and 3 only have partial lists that are in a different order from the original list. The details listed next to the names in sheets 2 and 3 are different and hence a straight forward row copy and paste will not work.

What i need is to write a vba script that can take the name from the master list, search sheets 2 and 3 for the name and lookup the variables placed in next to the name, then update the master sheet accordingly, then continue to the next name on the master sheet and do the update again, and so on until all is updated. I have already thought about using lookup functions in excel however there is 1000 names on the list and around 60 details so it would be messy.

View 6 Replies View Related

Formula To Find Multiple Values And Return Value

Mar 24, 2014

Column A:

pants A green
Pants B red
Jacket C green
Jacket D blue
Polo C white
....

I need a formula to find some value( in our case "colors" = "green, red, blue, white" ... = 20-30 values), and to return in column B, the values, like:

Column A: Column B:

pants A green | green
Pants B red | red
Modern green Jacket | green
blue winter jacket | blue
Polo white D | white

I have different product feeds (csv) and i will like to search for colors in the product names.

View 2 Replies View Related

Find To Search And Return Multiple Dates

Jul 31, 2007

I am working with a macro into which you input a date, the macro searches for that date (in column D of the data sheet), then copies any row with that date onto a new sheet.

This works great, but now I need to be able to search for more than one date at a time and return any rows that cantain ANY of those dates. For example, I would want to search for any row containing 01/01/07 - 01/07/07 or any row containing 01/01/07, 01/02/07, 01/03/07...01/07/07.

View 9 Replies View Related

Vlookup To Return One Value From Multiple Columns?

Sep 21, 2013

I have two separate worksheets, and I am trying to create a Vlookup or Index and Match formula. Here is the example:

Sheet 1
Cell A1= Employee ID: 123-D.

Sheet2
Vlookup A1 from Sheet 1, and match the first five characters to Column A, Column I and Column P. If a match, return name (e.g. John Doe) in Sheet 1, cell B1.

View 9 Replies View Related

Vlookup From Multiple Columns With Only One Return

Dec 19, 2008

I have a spreadsheet with twenty columns. Column A has an item number (say "Clutch"), and the remainder of the columns have values. However, there only be one column in the range B:T which will have a value on the same row as "Clutch" (say "Black" in column "N").

How I can I return "Black" using a vlookup or should I be using something else?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved