# Show Info In Column C, If A & B Match Criteria

Aug 20, 2009

What I'm having a hard time is trying to get information from column C to pull into a cell, for a specific student (column A), but only when the entry happens between two set of dates (column B).

Column A = Student Name
Column B = Entry Date
Column C = Entry

So in a different worksheet, the names of the students will already be on the report and each column following will have a date range of a week. So for column B I want the entry that only happened between "09/07/09-"09/13/09". No student will have more than one entry a week so I just want it to locate the entry and fill in automatically. This will repeat for each week after as well.

## Match Names In Two Separate Column If Equal Then Pull Info In 3 Column?

Dec 6, 2013

I need to look up the name in E2 in the list in column A and if it matches then lookup name in F2 in list column b, if it matches then the corresponding number in column C is displayed in column G. If neither names are in the 2 columns the words"Not on lists" is displayed in cell in column G.

The other problem is one name is spelled two different ways I want it to look for both spelling before moving on to looking up the second name.

I started with this formula but I'm getting #N/A or "not on list" when they are on the list. I'm using ranges prod_sum is columns AthruC, Last_name is range BthruC. =IF(AND(VLOOKUP(F4,prod_sum,3,0),VLOOKUP(I4,last_name,2,0)),"not on list")

## Reorganizing Data To Show Info From Two Separate Columns In Third New Column

Feb 5, 2014

I've got a problem with organizing my data. I've performed a study with several participants, each of which does several trials with 8 conditions (1,2,3,4,5,6,7, or 8), with each participant doing a condition more than once. I also have a separate column telling me whether they responded correctly or incorrectly (with a 1 or a 0).

I need to find a way to produce a new column to identify whether they got each condition (of the conditions 1,2,3,4,5,6,7, or 8) correct separately, i.e one column for responses to condition 1, one for condition 2 and so on....

It would also be useful if there was a way that once this is done I could summarize their accuracy of responses to each condition.

I've attached an example of my data. excel problem example.xlsx‎

## Match Data From Another Column And Populate Info

Mar 21, 2007

I am trying to match info from one column with another column and if it matches, I need the formula to populate the relevant data from the adjacent column. I using Vlookup and I am not sure why it does not work. I have attached a simple example.

## Formula To Match A Date And Once It Does The Info Stays In That Column

Mar 9, 2008

I would like for the result of a formula to stay in the cell even after the first cell changes.

in cell G1 I use this formula, if(C1=D10,A1,""), I would like result of formaula to remain in G1 even after C1 is changed.

## Look Up That Would Show All The Results That Match Certain Criteria?

Feb 14, 2007

I have a spreadsheet that holds salary information. At the moment it shows against each person the highest salary for a person of the opposite ***. What I would like to do is have another cell that shows the names of all people who have that salary.

E.g. if the highest comparable salary for someone of the opposite *** is 30000 then I would want a list of all the people with that salary.

Is it possible to do a look up that would show all the results that match certain criteria?

## Lookup 2 Criteria And Return Info In Specific Column

Feb 8, 2008

I've got a database that is sorted by date...

I need a formula that will look for 2 criteria and once it finds those 2 matching criteria, I need it to return the information on that line that's in column 6, let's say.

so in one column I have the date, the next column I have the sales persons name, 4 columns over I have their order number.

In cell a1 of worksheet 1, I have a drop down ready that has all my sales persons listed. In cell a2 I will manually enter the date that I need to reference.

I need the formula to then look for cell a1 and a2 in worksheet 2 where I have my spreadsheet with the info I mentioned above, match that criterium in worksheet 2, and return the info in column 6.

## Compare And If Match Show From Other Column

Mar 5, 2014

If i has this table name delivery

Table name is delivery and goes from a to p and 1 to 621.

## 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.

## Using Index And Match For Two Criteria - One In A Column Other In A Row

Dec 20, 2012

How to get the following index/match formula to work.

I have 2 criteria that I need to find the result of in a table that has the one criteria down the column, the other across a row at the top.

The formula I have is thus far:

{=INDEX(\$K\$46:\$AV\$46,MATCH(L98,IF(\$K\$15:\$AV\$15=N98,\$K\$27:\$K\$82),0))}

In this L98 is the criteria I'm in theory doing a vlookup against the values in column \$K\$27:\$K\$82, and N98 is the theoretical hlookup against row \$K\$15:\$AV\$15, bringing back the intersection point from row \$K\$46:\$AV\$46

All I get is #N/A .....

## Macro To Match Column Against Row Criteria

Feb 10, 2014

Trying to write a macro that will display either an 'X' or a date under a specific header if several conditions are met across a row in another tab.

I have two tabs, one is the report, the other raw data. On the raw data tab, if the macro finds a row where the title, territory, Rowdesc, start and end dates all match criteria, then display an 'X' next to that title in the report tab. The criteria would be:

Title Match - between Raw Data tab and Report tab
Terr_Nm column matches report header in Report Tab
Rowdesc = 'No Rights'
Start Date = the date 1-Jan-1900 or 1
End Date = * - an asterick

However, if the macro finds a start date that is greater than today, display this start date on the report where the 'X' would normally go. If the macro finds a start date that is less than today and an end date that is greater than today, then display the end date where the 'X' would normally go.

If the macro does not find anything, then do nothing and go on to the next row. In my example, 'Title 4' isn't on the raw data, so the macro would do nothing with this title.

Raw Data:
Title
Terr_NM
Rowdesc
Start
End

TITLE1
Terr X
No Rights
1/1/1900
*

[Code] ....

Report Tab, before running macro:

TITLE
Terr X
Terr Y
Terr A
Terr B

TITLE1

TITLE2

TITLE3

TITLE4

Report Tab, after running macro:

TITLE
Terr X
Terr Y
Terr A
Terr B

TITLE1
X
1/1/2015
X

[Code] ......

I've tried doing this with formulas (dcount, countif, etc.) and the problem is displaying the specific date. So, I'd like to use VBA to automate.

## Using Combobox To Show Info From Another Sheet

Jul 14, 2014

I would like to use the combo box to perform a search function. I have 4 columns of data and 2 sheets, The first column in sheet 1 is the "Name". By selecting the person name in the combo box, the data of that person would be shown in another sheet (sheet 2). And now I have a combo box in sheet 2. How can I do this using the combo box?

## Match 2 Criteria And Search Column And Return Value Based On Value

Feb 14, 2014

I have a spreadsheet that contains data for a fiscal year broken out by month and quarter. I want the formula to return the data from that month and use whatever the latest quarter is. For example in the data below:

If it has only pulled data only thru Q1 it would return Q1 for Jan-Mar, however once I have Q2 data I would want the formula to return Q2 for the months of Jan-Mar.

2013Thru Q1STOLISTOLIJan-2013STOLI BASE
2013Thru Q1STOLISTOLIFeb-2013STOLI BASE
2013Thru Q1STOLISTOLIMar-2013STOLI BASE
2013Thru Q2STOLISTOLIApr-2013STOLI BASE
2013Thru Q2STOLISTOLIMay-2013STOLI BASE
2013Thru Q2STOLISTOLIJun-2013STOLI BASE
2013Thru Q3STOLISTOLIJul-2013STOLI BASE
2013Thru Q3STOLISTOLIAug-2013STOLI BASE
2013Thru Q3STOLISTOLISep-2013STOLI BASE
2013Thru Q4STOLISTOLIOct-2013STOLI BASE
2013Thru Q4STOLISTOLINov-2013STOLI BASE
2013Thru Q4STOLISTOLIDec-2013STOLI BASE
2013Thru Q4STOLISTOLIDec-2013STOLI BASE
2014Thru Q1STOLISTOLIJan-2014STOLI BASE

## Formula To Delete Column If It Doesn't Match Criteria

Jun 2, 2009

I have a column of cells (Column I2:I1063) with zip codes in it and I want to keep the row if the zip code matches one on the list in a column B2:B100 on a separate sheet (Sheet1).

## Match Two Columns Across Sheets And Based On Criteria Of Another Column

Aug 10, 2009

This is driving me nuts. What I have is:

Sheet1:
ColumnB - number stored as text (Work ID)
Remaining Columns: - mixed data, some columsn numbers, some text

Sheet 2

ColumnA - number stored as text (Work ID)
ColumnB:ColumnAW - mixed data, some columsn numbers, some text
CollumnAX - Dollar Values

What I want is in Column F (Sheet1) a formula to:

if workID in Sheet1!ColumnB is present in Sheet2!ColumnA AND Sheet2!ColumnAX>1 then return True

## Copy Rows Where Cells In Column Match Condition/Criteria

May 5, 2008

I did a search to find a question similar to mine and I found this:
Copying data matching a criteria into another spreadsheet

This is exactly the same concept I am trying to accomplish, but don't know how to...at all. I couldn't follow the thread either.

I have a schedule which is constantly being updated (simplier version attached). I want to create a schedule, which will:
1) First ask which region to display the information for (I would like to create the same pop up menu to choose from)
2) Then, it will select only that region's information (all rows & columns) and copy them into a new worksheet and lists it all
-if you go back to the Master List, you can again choose another Region and it will create another new worksheet with that region's information
3) Don't know if this is making things more complicated, but at the bottom of the attached file, there are 3 lines under "Land".

Is it possible to list these under the same spreadsheet as the region it is pertaining to but classify it separately under "Land" (ie leaving space, so it is clear this is separate

## Lookup Column Of Data Match Criteria From Another Sheet Display Items Vertically

Feb 5, 2014

(File is attached here)

I am trying to work on Sheet 2(Details per person). I want to be able to display all items in a row that matches the 2 criteria (Skype ID and Date) and the items are based from Master Raw file which is in another sheet. I would like to just use index and match.

## Delete Rows But Save Info Based On Three Different Criteria

Aug 13, 2012

I want to delete the rows if they do not equal "TL" based on certain criteria, but save the info
then delete the rows if they do not equal "Fedex" based on certain criteria, but save the info
then delete the rows if they do not equal "LTL" based on certain criteria

After the information has been filtered it is supposed to load to a template giving monthly information for each of the above, but this is not working

VB:
If Load = "LTL" Then
Range("A2").Select
Selection.Sort key1:=Range("F1"), order1:=xlDescending, Header:=xlYes
For x = 2 To TotalRows
If Cells(x, 6).Value > 10000 And Cells(x, 1).Value = "FEDX" Then

[Code] ....

I am pretty sure that my problem lies within the parenthesis where it says Rows("2:" & x-1).Delete. Am I supposed to put something else there since I am deleting rows based on three different loads?

## Move Info In One Column Based On Data In Another Column

Aug 28, 2012

I am trying to move a column of numbers based on the information in another column. I've been looking for about a week and find macros that are close but not quite.

In one column it reads Mobile, Home, or is blank. If the number is a Mobile (column R), the area code (column P) needs to move to column S and the phone (column Q) needs to move to column T and the primary phone (column R) needs to move to column U. Home and blank cells remain as they are.

area (P)
phone (Q)
primary phone (R)
col S
col T
col U

[code]....

## Compare Two Cells In A Row With Criteria. Count Rows That Match Criteria

Sep 22, 2009

Here is what I have. 4 Worksheets. The first worksheet is a summary page. I have 350 personnel that are broken down into three different groups. So each group has it's own sheet. Here is what I need to accomplish. Results need to be posted on the summary sheet.

I need to compare cells B2 & D3 for each row on a worksheet and display the number of times they match on a worksheet. For example how many times does EP & EP match on a certain row. I need to compare cells B2 & D3 for each row on a worksheeet and display the number of times they don't match on a worksheet. For example how many times does EP & MP occur. I've attached an example for reference

## Provide Filter With A List Of Criteria But When It Doesn't Match All Of The Criteria?

Apr 1, 2014

Is there a way to provide filter with a list of criteria but when it doesnt match all of the criteria it still uses the filter on the criteria that it does match?

E.g i have this code

ActiveSheet.Range("\$A\$7:\$N\$31997").AutoFilter Field:=1, Criteria1:=Array( _
"A", "B", "D", "E", "H", "I", "R"), Operator:=xlFilterValues

However sometimes for example B will be missing, or H or B H I will be missing etc... is there a way to provide all of the criteria and it will not error if the criteria is not all there?

## Removing Information From Column A With Associated Info From Column B

Jan 17, 2008

I am attempting to Organize some data; however, I have run into a problem. I will paste a sample of the data that I have and explain the situation....

## Pulling Info From Column

Jul 8, 2014

I'm copying and pasting data from a PDF and need to eliminate some unnecessary data. The original .pdf has 4 columns: Account, Dollar Amount, Name, Notes

When I copy this to an excel document, it copies the row from all 4 columns into column A. The two columns I need are Account and Dollar Amount. All account numbers are 8 digits so I was able to create a formula to weed that out with this: =left(A1,8)

The problem I'm running into is obtaining the dollar amount within the cell. For example:

A1 contains: 11112222 \$1234.56 Sample, Name Sample Note

I pull the 11112222 with =left(A1,8) in column B but not sure how to pull dollar amount to column C.

Further, the dollar amount varies from \$1.01 to \$10,000+

## Sorting Info In A Column

Apr 17, 2009

I need to sort information in a column containing both numbers and words. In the "asending" & "desending" it only gives two options to choose from. (none) & PartNum.

## If Two Criterias Match, Value Should Show As 1

Aug 27, 2009

If column A is greater than B and column C is blank then Column D should show value as 1.

ABCD
15121

Similarly if column B is greater than A and column C is blank then Column D should show value as 2.

ABCD
12152

Can I put both the formulas in one column so that I get the value as 1 or 2?

## Fill Info In Sheet One And Have Same Info Appear In All Sheets That Follow

May 12, 2014

I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?

## How To Fill Vertical Columns With Info From Horizontal Info

Aug 22, 2014

I have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g

The info in these columns at present has been manually entered but I am sure it could be automated.

OOL Roster Final 18-31Aug14.xlsx

## How To Find Where Info In Column A Is Repeated

Apr 9, 2008

I have three columns

"A" is item number: "B" is sales Date: "C" is sales price.

What I would like to do is search column A and when there are two of the same item numbers know what date they sold and for what price. I would prefer to build another table that has only this data.

## Extract Row And Column Info From .address

May 21, 2009

The following code sets foundcell.address

## How To Split Info In Cells / Column

Feb 13, 2012

I have data that I've converted from a different source, and the formatting doesn't always come out as I'd like it. For example, I have data that has two different values, and I need to split them into different columns. Is there an easy/quick way to do this?

15* 27016* 1324517* 2086518* 24943