Search
Search titles only
By:
Search titles only
By:
Forums
New posts
Search forums
What's new
New posts
Latest activity
Feedback
View Statistics
Members
Current visitors
Buy Sell Trade
WTB
Log in
Register
Search
Search titles only
By:
Search titles only
By:
New posts
Search forums
Menu
Install the app
Install
Reply to thread
Forums
Technology
Computer Software
Microsoft Excel - Data Matching Help
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="RD274" data-source="post: 1247209" data-attributes="member: 29626"><p>My moms new job requires that she goes through large lists of data in Excel and check to see if values match or not. So she asked me to figure out a quick formula to check if a value matchs or not. </p><p></p><p>So using IF and VLOOKUP, I managed to get it to compare values of single cells. But I have no idea <strong>how to get it to search through the entire list and identify which values match and which don't match</strong>.</p><p></p><p>I've tried Goal Seek but I can't get it to work with my data. Any other simple solution?<span style="color: gold"></span></p><p><span style="color: gold"></span></p><p><span style="color: gold">--- Updated Post - Automerged ---</span></p><p><span style="color: gold"></span></p><p><span style="color: gold"></span><p style="text-align: center"><img src="http://lh6.ggpht.com/_tesw-W5SZKg/TPfUr1YHxsI/AAAAAAAABBU/UpWvARnL-YQ/s640/temp.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>^Heres my current temporary worksheet. I've got table blue and table red, both are identical except value 9 of table blue.</p><p></p><p>I'm looking for a simple solution to go through the values of table blue and table red and report any false value (Eg. value 9 of blue table) or at least stop at a false value.</p></blockquote><p></p>
[QUOTE="RD274, post: 1247209, member: 29626"] My moms new job requires that she goes through large lists of data in Excel and check to see if values match or not. So she asked me to figure out a quick formula to check if a value matchs or not. So using IF and VLOOKUP, I managed to get it to compare values of single cells. But I have no idea [B]how to get it to search through the entire list and identify which values match and which don't match[/B]. I've tried Goal Seek but I can't get it to work with my data. Any other simple solution?[COLOR="gold"] --- Updated Post - Automerged --- [/COLOR][CENTER][img]http://lh6.ggpht.com/_tesw-W5SZKg/TPfUr1YHxsI/AAAAAAAABBU/UpWvARnL-YQ/s640/temp.jpg[/img][/CENTER] ^Heres my current temporary worksheet. I've got table blue and table red, both are identical except value 9 of table blue. I'm looking for a simple solution to go through the values of table blue and table red and report any false value (Eg. value 9 of blue table) or at least stop at a false value. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Technology
Computer Software
Microsoft Excel - Data Matching Help
Top
Bottom