Find Cell That Contains Certain Text And If It Exists Compare 2 Other Cells

Jun 25, 2013

I've a spreadsheet and I need to find cells in Column A that contains certain text and subsequently being able to compare the data in 2 other cells (column F and Column J) and post the results of comparison in Column L. Please see the tables below:

In this table, if Range("A1") contains abc, then data in Range("f1") would be compared against Range("J1"). If F1 = J1, then Range("L1") would say "ok" otherwise "needs to check" as in Rows 2.

Please note that the amount of data varies daily.

Column F
Column L



needs to check


View 1 Replies


Compare Cells And If Exists Display Cell Value?

Sep 10, 2012

I need a formula that will look at cell A1 and compare it against column B, if it finds it, show that value, if not, show "not found".

View 6 Replies View Related

Compare Text In Three Cells - Return With Yes Or No In Fourth Cell

Jul 10, 2014

I have three cells - A1, B1, C1 and each contains a value of yes or no.

If more than two of the cells say "yes", I want the fourth cell (D1) to display "yes."

If less than two columns say "yes", I want the fourth cell (D1) to display "no" .

View 3 Replies View Related

Compare Cell To Many Cells & Return Relevant Text

Feb 22, 2008

I have a if function that i am creating in excel 2000, and it has 8 variables. I am trying to put it in a macro as it is not working as a nested if function. Here is the current if function...

=IF(B2=C2,"OK",IF(B2=D2,"OK",IF(B2=E2,"OK",IF(B2=F2,"OK",IF(C2=0,"OK",IF(D2=0,"OK",IF(E2=0, "OK", IF(F2=0, "OK", "INCORRECT"))))))

the excel file is attached for further clarity

View 3 Replies View Related

Compare Identical Text In Two Cells On Two Sheets - Return Value On Target Row Into Cell

Jan 2, 2013

I have a workbook with tons of programming I need to achieve. Here is my work book so it can be viewed.

Right now on "Protocol" Sheet I want the cells with the "Protocol 1" field to look at Admin_Panel Sheet and find the row with the same text. Then take the text in cell A of the same row and copy it to the cell below the "Protocol 1" listed on the protocol sheet.

View 3 Replies View Related

How To Check Whether A Text Exists In A Group Of Cells

May 5, 2009

What I want is to find out whether a value in a node can be found from a group of other nodes. I've tried lupike this, but it doesn't seem to work properly.


I guess one solution could have been using concatenate function, but why on earth can't I use the function like this: concatenate(A1:A5)? Why do I have to put each term individually?

View 11 Replies View Related

Find Column A Cell Value If It Exists For Current Cursor Row Position

Dec 1, 2012

trying to find the value of column A (date field) if it exists on the row that the cursor is presently on. I'm trying to check for the value before performing the next function to make sure the user is on a valid row. Cursor could be on any column A to F. Columns are always 6 but the rows can vary.

View 7 Replies View Related

Compare Multiple Text Cells To One String Of Text And Return Specified Value

May 12, 2012

I have a dataset of shifts and want to compare each shift that needs to be filled to a list of requests for time off (vacation, etc).

For one cell the code is: =IF(ISERROR(SEARCH(B1, A1), 0,1)

Where A1 is the column of requests in comma delimited forme (ie: "AB,CD,EF").

Where B1 is the column containing the person assigned to shift 1 (ie: "AB")

In this case, would return a "1" as no error was returned, as AB was found in the list. Here "1" would represent a schedule conflict.

Without creating many cells for each shift- there are 20 shifts- can I create an array or string together this type of "SEARCH" function?

View 1 Replies View Related

Count / Sum Numbers In Column Where Specific Text Exists In Adjacent Cell

Jan 19, 2008

One has numbers the other has "YES" or is blank. I want a formula to look at the second column and where there is a "Yes" then count the number in the same row in the first column.

View 4 Replies View Related

Find Text In Cell Using Cells Object Within IF Then Statement

May 3, 2014

I am trying to find particular text in a cell then format adjacent cells in the same row. In my code below I am trying to search for "*[Tx]*" using Like, however this is formatting all text that contain "T".

View 7 Replies View Related

Display Text In Cell Only If Value Exists In Different Cell?

Jan 3, 2012

Let me see if I can make this succinct and clear. Cell AQ2 (where the formula below resides) looks at the value in cell E2. It then references table $K$3:$U:$100 on sheet "LookupTables" to get the value to display. It does this (and works great) with the formula below:


I would like to add one more argument. I would also like it to reference cell U3 in the LookupTables sheet and if there is anything in that cell to go ahead and complete the formula, but if there's no value in that cell, it should return no text and be blank

View 4 Replies View Related

Compare Text Between Cells

Oct 1, 2009

I've got a very big spreadsheet with over 40,000 lines.

The text is sorted alphabetically, and on its side I'd like to have a column displaying how different it is from the cell above.

A1 - Mediterranean Sea. -----
A2 - Mediterranean Ses. ----- 5.55%
A3 - Atlantic Ocean. ----- 100%

Basically, 'Atlantic Ocean' is 100% different from the cell above, but A2 has only one letter different (out of 18, including the space and the dot) compared with A1, so it's only 5.55% different.

This would help me find which cells that are supposed to have the same content, have errors and thus are slightly different.

View 13 Replies View Related

Compare Text Cell With Numeric Cell And Output Text String

Mar 25, 2014

As per title, I am trying to compare a column of text cells which contain "Yes" or are empty and a columns of numbers. If they are "Yes" and "1" on the same row, I want to output an "OK" message. Excel seems happy with the following code but it does not work and returns an empty cell if the two conditions are true.

[Code] .....

View 6 Replies View Related

Compare Text Strings In Two Columns And Return Text From Adjacent Cell

Feb 28, 2013

how to Chk the text string in particular cell, compare it with a super set column and get the full from of the text string from another corresponsing column and the output will be corresponsing full form of the chked text string?

View 6 Replies View Related

Search Compare Text In Two Cells

May 25, 2007

I have one sheet and i want to compare the first word in the column "D". If the first word of D2, is the same than the first word of D3, i want to copy to another sheet and after the copy, insert 2 blank rows... if it's different, i want to copy and insert 3 blank rows

Maybe it's better to attach the file. In the first sheet, you'll see a little part of the real sheet, and the second sheet is the example of what results i want to obtain with code...

View 6 Replies View Related

Compare Cell Text To Set List And Show Text Differences

Dec 5, 2009

I am trying to write a function that will compare the text of cell "A2" to the text of cell "B2" and display cell "A2"'s text characters that didnt match from cell "B2" in column C. Can anyone help me out with writing this formula?

EX: ....

View 9 Replies View Related

Find Blank Cell And Compare...

Jun 29, 2009

I am trying to write a macro and i am having trouble hgetting it right. I have large amount of data in columns and what I would like to do is the following.

1. First I need to find the first blank cell in that row.

2. After finding the blank cell, I would like to compare the value in 3rd column from the blank cell( For example if the last blank cell is Row1,ColumnR then I need to Compare Row1,ColumnO) with Column E ( Is always Column E).

3. Based on above example if Row1,ColumnO>Row1,ColumnE, then goto next row else Row1,ColumnR value should be Row1,ColumnE and I would like to get Row1,ColumnS and Row1,ColumnT vaues to be same as last 2 columns from the blank cell which was determined first (i.e., from above example Row1,ColumnS and Row1,ColumnT vaues to be same as Row1,ColumnP and Row1,ColumnQ).

4.I would like to perform the above procedure for all the rows in the worksheet and the blank cell may be anywhere in the column for that particular row.

I don't know whetehr it is possible to write a macro to perform above procedure or i need to do that manually which i hate as i have large amount of data.

View 3 Replies View Related

Compare Two Cells And Delete Row If Text Is True?

Apr 6, 2014

Find the attached : example.xlsx‎

My requirement is compare two cells a1 & a2 if found true highlight a2,compare a2 & a3 if found same highlight a3 or compare a3 and a4 and repeat the same for the entire sheet.

View 1 Replies View Related

Compare Excessive Text In Two Cells And Show Differences

Jun 19, 2014

Is it possible to compare code that's in two cells and show the differences? It's possible with Notepad++ and an extension but I have hundreds of pages to examine weekly and it's not efficient to do it manually.

View 1 Replies View Related

Find Text Within Cells & Place Same Text In Adjacent Column

Apr 10, 2008

I want to search for a word in column A and when I find it I want to copy it to column B.
Column A is a description that can be 6 or 7 words long. Column B is a single word.


Col A
Engine Kit, V-8, 306, forged.
I need to copy the word Kit to column B.

View 9 Replies View Related

Find If Named Range Exists In Sheet Using VBA

Nov 17, 2011

How can i find if a named range exists in a sheet using VBA?

E.g.: I have a named range called test that houses 4 numbers in four cells. Using

Dim rtest As Range
Set rtest = Worksheets("sheet1").Range("test")
rFoundCell = _
Cells.Find(What:=rtest, After:=Range("a1"), LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:= _
xlByRows, SearchDirection:=xlNext, MatchCase:=False)

Won't work. Run - time error 91 occurs.

View 9 Replies View Related

Compare Cell Values Numbers From Text

Jan 22, 2009

I have the following:

cell B2 value = "P1'08"
cell C2 Value = "P11'09"

cell H1 Value = "P4'09"

The value stands for the Periodnumber and a Year so P1'08 stands for period 1 in the year 2008.

In cell H2 I want the following:

If value in cell H1 is the same as B2 or C2 or is in between these periods then the value in H2 should be the value of cell D2. If not the H2 should be empty.

View 10 Replies View Related

Join Cell Text & Compare With Case Sensitivity

Jul 20, 2007

Looking for formula with if then statement that involves a nested formula or concatenation. I need a formula that says: If cell A reads exactly ABCD then concatenate cell A with cell C. Very basic to most of you gurus but I'm fairly new with formulas.

View 3 Replies View Related

IF.. Contains...then: Search Through The Text String In That Cell And Find A Certain Word, Find And Retrn A Value

May 23, 2006

I am having trouble getting my IF statement to test if the cell contains the text "sale" return "X" if not "Y". I need it to search through the text string in that cell and find a certain word, and if it finds that word, retrn a value. I am really having difficulty with is what symbol or function do I use for the logical test? (i.e. =, <>, MATCH, INDEX?)

View 4 Replies View Related

To Compare Two Cells, And If The First Cell Is Either

Oct 4, 2009

I'd like to compare two cells, and if the first cell is either >150, <161, OR =165 AND the second cell is ="E" to output a 1, and if false, output a zero.
I have =IF(AND(AND(Sheet1!B3>150, Sheet1!B3<161, Sheet1!B3=165 ),Sheet1!E2="P"),"1","0")

But i know that is incorrect because Sheet1!B3 can not be greater than 150 AND less than 161 AND = 165. I can't figure out how to make it >150 AND < 161 OR = 161.

View 14 Replies View Related

Compare A Cell With A Number Of Other Cells

Jan 13, 2009

I want to compare a cell with a number of other cells to check if their value is the same. If it is the same an IF function will perform some action.

For example I want to check if A23 is equal to B23,B24,B25.....B50

Something like IF (A23= B23 to B50,"hi","bye")

The problem is that I dont know how to write "B23 to B50" in a format Excel will understand.

View 12 Replies View Related

Compare 2 Cells If One Cell Is Greater Than 0

Mar 6, 2007

I need a formula for: If cell c is greater than 0 and cell c is<> cell b return value of cell c in cell d; else value of cell b in cell d.

View 4 Replies View Related

Compare Cells For Conditions & Color Corresponding Cell

Sep 26, 2007

I am trying to add a third if statement to my existing code looking to see if a cell in a column is blank and the corresponding cell in another column contains a number that is greater than or equal to 1. I can't figure out how to write that part of my IF statement.

If Cells(r, 4) = " " And Cells(r, 3) >= 1 Then
Cells(r, 1).Resize(1, 5).Interior.ColorIndex = 35
Set rng = Union(Cells(r, 1), Cells(r, 3), Cells(r, 4))
Worksheets("Sheet1").Range("G40:I40").End(xlUp).Offset(1, 0).PasteSpecial (xlPasteValues)
Application.CutCopyMode = False
Cells(r, 5) = "NEW"
End If
Next r

View 4 Replies View Related

Lookup Function: Compare Every Part In The All Parts Worksheet To See If The Part Number Exists On The Active Parts Sheet

Dec 10, 2008

I have a spreadsheet with 2 worksheets. On the first "active parts" I have a list of active part numbers and on the second "All Parts" I have all of the parts available.

I want to compare every part in the All Parts worksheet to see if the part number exists on the Active Parts sheet - if it's there, I would like it to return the value "Active" in column B in All Parts. I have a formula in column B in All Parts that seems to work for the first few, but as soon as it finds one that is active, the rest of the cells below all return "Active".

View 3 Replies View Related

Compare Two Cells If They Match Then Fill In The Cell From Another Sheet?

Oct 19, 2012

I am trying to compare two cells and if they match then I want to fill in a list on sheet one from sheet two.

I have the absolute working when I compare one cell to one cell, but I can't get it to compare one cell to a range of cells (two weeks of days)

Here is the absolute one I have working:

=IF(C1='Data Sorted'!A1,'Data Sorted'!A2,"")

Here is what I tried that doesn't work:

=IF(C1='Data Sorted'!A1:N1,'Data Sorted'!A2,"")

View 6 Replies View Related

Copyrights 2005-15, All rights reserved