Solved

# Updating a column in Excel based on the data in other columns and rows

Posted on 2012-03-28
193 Views
I have a file that is sorted by Column D which I am calling "Old_Id".  Column B which is called "Match Found" has a value  of "Y" set by another program.

Is there a way to update Column A "ID Match" with a "Y" if  there is a "Y" in column "B" in any row where Column "D" is the same.

(See attached file).  The results I would like a formula for are in Red Font.
Match-Found.xlsx
0
Question by:morinia
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
1 Comment

LVL 1

Accepted Solution

Bob60618 earned 500 total points
ID: 37779092
1. Sort the file - OLD_ID Lowest to highest then Match_Found Z to A (get Ys on top for each ID)
2. The formula for cell A2 is "=IF(B2="Y","Y",IF(D2=D1,IF(A1="Y","Y",""),""))"
3. Copy cell A2 down
4. Use conditional formatting to turn "Y" to red.
5. See attached
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to usâ€¦
###### Suggested Courses
Course of the Month11 days, 5 hours left to enroll