# From Matching Numbers In One Column Return Value Of Second Cells In Another Cell?

May 19, 2014

I have a table with 4 columns where in column 3 I have part numbers and in column 4 I have the number sold. In column 3, the part sold can be listed several times with a different number sold in the column 3. What I need is code to go through the part numbers and return a total number sold for that part in a new column. I have sorted the table by part number, then by Column 1 which is for the date. The new total should go in the last column with the oldest date for that part.

## Return Matching Numbers By Comparing 2 Ranges

Apr 30, 2008

I have a collum (A )with numbers and in other sheet have a collum (B)with numbers too.. and some numbers match. what i want is in the cells that the numbers match have other colum and i want to copy that number to another cell.

## Matching Pairs - Column To Automatically Populate With Any Of 3 Digit Numbers That Share Two Numbers

Mar 12, 2013

This is what I need:

Columns B, C, D & E are all populated with 3 digit numbers.

I would like column F to automatically populate with any of the 3 digit numbers that share two numbers, i.e.

F2 might look like this (using 00 as the pair):

001, 040

F3 might look like this (using 01 as the pair):
701, 051, 110, 001, 120

F4 might look like this (using 12 as the pair):
123, 721, 281, 912, 112, 120

etc...

## Deleting Rows Matching Numbers From Numbers In Column

Sep 11, 2008

I want to delete rows in whole list and numbers of rows to be deleted I have in for example C column. How to do it?

## Nested Index / Match Array - Return Value In Column C When Matching Column A And B But With Few More Criteria

Jun 7, 2014

I am trying to use a nested INDEX and MATCH array formula to return the value in column C when matching column A and column B, but with a few more criteria.

The range containing all the data

A
B
C

1
Cat 1
January 1, 2014
John

[Code] ..........

I am looking for the array formula to return the name of the person in column C who is in Cat 1 after the date in column B.

For example;
C7 should return "John" because B7 requests "January 15, 2014", which is after the value in B1
C8 should return "John" because B8 requests "February 15, 2014", which is after the value in B1
C9 should return "Andrew" because B9 requests "August 15, 2014", which is after the value in B4

The best try I had for the formula in C7 was

{(INDEX(\$A\$1:\$C\$4,MATCH(1,(\$B\$1:\$B\$4>=B7)*(A\$1:\$A\$4=A7),0),3))}

This brings back "John" as desired in C7, but when copying down the table into C8 and C9 both C8 and C9 return Andrew.

I guess this is due to my ">=" condition in the Match formula and it is returning "Andrew" because "Andrew" is also after the date requested, but I cannot for the life of me work out how to get it to work.

## Split Range Of Numbers From One Cell Into Column Of Multiple Cells All With Individual Numbers

Mar 5, 2012

I have a mass of data which look something like this:

table removed

and I require the ranges of reference numbers to be listed in a column one above the other, which requires inserting new rows. I also need the date & description columns copied down into the newly inserted rows.

So basically for example I would want the top row to now read:

table removed

and then apply the same procedure to the other ranges below this.

## Return Value In Third Column If Values In First Two Columns Matching?

Mar 20, 2014

I have a two different workbooks book 1 and book 2 with some data.

If values of first two columns ( Column A and B) of both workbooks are matching then I want a formula that can return the value of third column (column c) of book 2 in book 1 column c.

example:

Book 1

column A / Column B / Column C

100 / 200 /

Book 2

Column A / Column B / Column C

100 / 200 / 300

now I want a formula that can return in column C of book 1 to display 300.

And the data runs across some 100 rows in both workbooks.

## Matching Combination Of Two Cells With A Table And Return Value

May 8, 2014

As shown in the attachment, I'm trying to return value when matching cell B7 + D5 with cell G5:I7. Is there any way to do so?

Attached File: File Type: xlsx Book1.xlsx‎

## Average Column Of Cells But Ignore Errors And Return Average Of Numbers That Are There

Jun 14, 2013

E11 through E24 contains numbers and a few errors (#N/A) that need to persist (the errors need to show).

E10 needs to show the average of the numbers that are in E11 through E24, and just ignore the errors.

I have many columns like that - where the errors need to show and I need to show an average of the number/values that do appear, ignoring the errors.

## Return Highest Value Of Column Headings With Matching Text In Array?

Mar 7, 2013

I have an array of data with multiple codes stored in text...

I want to set a formula in a cell to look for all instances of specific text in an array. Then compare the value of all of the column headings, which are numbered across the top of the array, which contain a match in that column and return the highest value.

Example: 10x10 array, columns 1,3, and 5 contain "text" somewhere in those columns. Formula would return 5.

## Find Cells Matching Value & Return Adjacent Details

Feb 21, 2008

On Pipe worksheet, pipe numbers 1-203 are listed in column A. Each pipe number has a flow rate that is listed in column E. I need it to look up the pipe number in column A on the Job worksheet and report the flow rate (from the Pipe worksheet) in column D for each pipe.

## Match Function To Return Column Number For Matching Date Errors?

Aug 5, 2014

I am trying to use some vba match function code to return the column number of the matching date. The date will be stored in a date variable.

Every time I run this code I normally get a match error even though the date is in the worksheet and the variable matches that date.

See below:

[Code] .....

## Formula To Find Matching Values In One Column And Return Totals For All Rows That Match

Dec 26, 2013

table1.jpg

I am looking for a formula that will satisfy the following:

1) find all the values in column "A" that match
2) In column "G", sum up all the values in "F" that go with the matching values in column "A"
3) For example, in rows 14-16, the values in column "A" match. Cell G16 sums up F14:F16

## Create Hyperlink From Numbers In Column To Matching File Names In A Folder

May 21, 2013

I need a macro to create a hyperlink i.e....... I have an excel sheet with numbers in column A.....I have files in a folder that matches the numbers in column A....

How would I create a macro to create a hyperlink from the numbers in column A to the "matching" file names in a folder?

## Index Matching Numbers To Conditionally Format Cells Value Change?

Jul 29, 2014

I have the same report, one a monday snapshot, the other a daily comparison. I would like to index columns B, in both reports, to find the same part number and then reference the horizontal row and highlight increases in columns G thru AD. The comparison report looks identical but the column B numbers may not be in the same location. this is a report to show prosduction requirements and the increases throughout the week.

## VBA Code To Go Through Column Cells & Return Value Based On Cell Value

Jan 29, 2010

I have been stuck for about a week on trying to create a Case Select macro. I am a novice in using VBA, so I am not sure what I am doing right OR wrong. What I need the macro to do is go through all of the text in a column and if the text is one of the 50 states, I need it to return one specific value, and if it is anything other than one of the 50 states, it needs to return a different value in a column 5 over from the column with the states in it. I have changed the code MANY times and so far I haven't been able to get anything to work. Here's the gist of what I have been trying:

Sub usstates()
Dim R As Range, s As String
Set R = Sheets(1).Range("J1:J50000")
For i = 5 To R.Rows.Count
X = UCase(R.Cells(10, 1))
If X = "AL" Or X = "AZ" Or X = "AK" Or X = "AR" Or X = "CA" Then
R.Cells(i, 2) = "SC"
End If
Next i
End Sub.................

## Return A Value Of Two Matching Cell Values From Another Sheet

Jan 7, 2010

I have two sheets - one work sheet and the second - database with existing entries. Going by visual example below, I need the column C of the work sheet to automatically populate with the data pulled from the database sheet. For example, C4 on the Work sheet should find both values "Bike" and "Green" in one row on Database sheet and return the corresponding value 44444 from F97. The work sheet cells in the row C should remain empty if no match found on the database sheet.

Sheet 1 (Work sheet)
-------A--------B---------C
1---Auto-----Red
2---Auto----Green
3---Bike-----Red
4---Bike----Green
5---Bike-----Blue

Sheet 2 (Database)
-------A--------B---------F
12---Auto---Red----11111
37---Auto--Green---22222
85---Bike----Red----33333
97---Bike---Green--44444
102--Bike---Blue----55555

## Column Formula For Matching Cells?

Apr 1, 2014

I'm currently having a hard time creating a formula to verify if the contents of 2 cells match.

Column C: MATCH / NOT MATCH
Column D, Row 4: MSG
Column E, Row 4: SMSG

When I attempt to create a formula for Column C, it registers the "MSG" within "SMSG" and lists the result as "MATCH".

## Return All Row / Column Numbers Of All Occurrences Of A Value In Database

Jul 8, 2014

Say I have a certain range in excel from A1:C10. All of these cells contain one of three strings: Math, English, or Reading.

Given an input of ONE of these three (for example, a user can select "Reading"), the program should output ALL the row&column numbers of each occurrence of "Reading" in the range. Ideally, this would appear in a column.

Consider the following image that contains a sample range:

Screen Shot 2014-07-08 at 12.26.15 PM.png

If "English" is the input, the output should be (in another column)

A1
A7
B3
C2
C3

## Show Rows With Matching Cells In A Column

Dec 12, 2011

I have a sheet with some survey data. the data covers about 4 months. There are about 2200 rows and 8 columns.

The "code" could be in there more than once as the person took the survey multipule times, but all other data is different. How can i pull out the whole row when the code is there more than once.

I want to know all the "codes" with multipule entries that took the survey more than once then trend there scores.

CentercodeRecommendReasonEnvironmentTraining ManagerOverall LHQTR27909415Learning effect4444LHQTR28844652
Center environment2222LHQTR45614375Service5555LHQTR96944292Service2222LHQTR144769543
Center environment4433LHQTR144769543Learning effect3433LHQTR155258791Service3213LHQTR168772563
Center environment2232LHQTR168772563Center environment3332LHQTR168772565
Learning effect4414LHQTR173991905Learning effect4445LHQTR192966385Service5555LHQTR193282534
Qualified teachers3344

## Copy Matching Cells In Series From Column

Sep 2, 2007

in writing a macro that does the following.

Right there data in cell A1 lets say LTP BY001 and then the next data in column A is LTP BY002 in cell A9. What I need to do is copy LTP BY001 from cell a2-A8 and then LTP BY002 From A10 until LTP BY003 appears lets say A15. Therefore need LTP BY002 copying from A11-A14. I need that to go right the way down the workbook at everytime their is a number change.

## Return All Row Numbers That Have Given Value Written Somewhere Inside Text In Column B

Jul 24, 2013

By "Return all row numbers that have a given value written somewhere inside text in their column B" I mean....

I want to be able to search an alphanumeric value "ABC12345" within a column that has a paragraph of text written in each row, I want to know which rows have this value written somewhere in them and have it return 2,4,33, as row 2 and 4 and 33 have this value in them inside column B on that row.

on column A i have the respective row numbers all the way down ie: ( 1,2,3,4, etc) (to pull up the row numbers)(unless you have a better way)

On Column B i have the paragraphs of text to search in (there is lots of text and spaces in the paragraphs.)

On column C i have the value to look for... ie: ABC12345 (different values in each row of column C) to be compared to all of column B

On column D would be the formula to Pull down and get the results.

and something tells me you might have a better way of getting the row numbers rather than having column A dedicated to numerating each row 1,2,3,etc

1
paragraphs of text
look for
it's found in row #

2
anything can be written here and might have ABC11112
DDD77777
4

3
anything can be written here and might have ABC12345
ABC55555
5,6

4
anything can be written here and might have DDD77777
BBB11111

5
anything can be written here and might haveABC55555
ABC11112
2

6
anything can be written here and might haveABC55555
ABC12345
3

## Populating Cells Based On Row And Column Labels Matching

Oct 24, 2013

Having a bit of trouble trying to get excel to pick up text in one sheet (sheet 2) and populate cells in another (sheet 1) if the row (row 1) labels and columns (column a) in both sheets match. hope that makes sense? I've tried googling this to no avail, i've also tried index-match however i keep getting errors.

## Return X Characters Based On X Cells Having Whole Numbers Above Zero

Sep 14, 2007

IF there is a whole number in either column a, b or c, I need to have column e reflect that with the insertion of a / for each column that has a whole number. i.e.

Column - A - B - C - D - E
3 4 / /
5 6 9 / / /

I am attaching a copy of the spreadsheet showing the examples, I can't seem to get the function to work.

## Address Of Smallest 5 Numbers (return The Value In Column 1 For The Smallest 5 Numbers)

Jan 14, 2010

I am using the following array equation to return the value in column 1 for the smallest 5 numbers. It works for small 1 and 3 but i get a #NUM! for 2 , 4 , and 5. The smallest 5 numbers are:

0
3.196408441
4.491972091
4.491972091
4.491972091

Equation:

## Aligning Cells Based On Matching Data In Column Pairs?

Aug 13, 2014

I've got 3 pairs of columns and I need to sort through them and align the cells in columns E&F with those in A&B and C&D. The cells I need to match up are the times (columns A, C and E)

Example - convert this:

A...............................B..........C...............................D.........E...............................F......
30/07/2014 14:21:04.....6.10.....30/07/2014 14:22:37.....6.13.....30/07/2014 14:21:04.....6.13
30/07/2014 14:21:06.....6.11.....30/07/2014 14:22:54.....6.13.....30/07/2014 14:22:37.....6.13
30/07/2014 14:22:37.....6.11.....30/07/2014 14:22:56.....6.13.....30/07/2014 14:22:54.....6.13
30/07/2014 14:22:54.....6.11.....30/07/2014 14:22:56.....6.14.....30/07/2014 14:22:56.....6.13
30/07/2014 14:22:56.....6.11.....30/07/2014 14:22:59.....6.13.....30/07/2014 14:22:59.....6.13

Into this:

30/07/2014 14:21:04.....6.10.................................................30/07/2014 14:21:04.....6.13
30/07/2014 14:21:06.....6.11........................................................................................
30/07/2014 14:22:37.....6.11.....30/07/2014 14:22:37.....6.13.....30/07/2014 14:22:37.....6.13
30/07/2014 14:22:54.....6.11.....30/07/2014 14:22:54.....6.13.....30/07/2014 14:22:54.....6.13
30/07/2014 14:22:56.....6.11.....30/07/2014 14:22:56.....6.13.....30/07/2014 14:22:56.....6.13
............................................30/07/2014 14:22:56.....6.14............................................
............................................30/07/2014 14:22:59.....6.13.....30/07/2014 14:22:59.....6.13

I don't know VBA so hopefully there's a way of doing this with a basic Excel function.

## How To Return Address Of Column Or Cell Select Not Just Return Value

Aug 18, 2014

How to return address of the column or cell I selected from Application.Inputbox, not just return the value?

[Code] ....

## VLookup Random Numbers - Sort Range In Descending Order And Return Relevant Value From Column

Aug 27, 2012

I have a column (B) of randomly generated numbers 1-14, and am using this formula range to sort in descending order and return the relevant value from column (c).

=VLOOKUP(LARGE(B3:B20,1),B3:C20,2,) to =VLOOKUP(LARGE(B3:B20,14),B3:C20,2,)

Works great, except when a number is duplicated, (E.G. 14,13,13,12,11,10,10,9,8 etc). It then returns the first value from(C) repeated, and not the value from the second and subsequent duplicated reference numbers.

## Lookup/Match: Compare A1 For The Values In Column B, Then Return The Corresponding Cell (column C) In Column D

Jan 31, 2008

I've been searching the forums for this problem but I can't seem to find any answers. Anyway, this is the problem. See screenshot.

I want to compare A1 for the values in column B, then return the corresponding cell (column C) in column D.
e.g. D1 = 2, D2 = 1, D3 = 4, D4 = 5 and D5 = 3.

## Matching Cells In Column B To Cells In Column A?

Mar 20, 2014

i have stores numbers in column a and the sets and cartons in column b but there is gaps between the data i want in column c a list of stores with the set and car displayed next to it, some information in column b is on 2 rows for 1 store please see attached, how i would like to see it on a row is b345 car011119 etc