PC Review


Reply
Thread Tools Rate Thread

Comparing 2 cells using vlookup

 
 
=?Utf-8?B?UmF2ZW5zIEZhbg==?=
Guest
Posts: n/a
 
      13th Nov 2007
I am attempting to compare 2 cells in one file and bring another cell over if
true.

In my 1st file I have a number Cell a2 = 988881, Cell b2 = 203, d2 = 204, f2
= 205. In my 2nd file I have the same scenario except b2 can equal 203, 204,
205. I want to do a vlookup into my 1st file and once it finds 988881 then go
to cell B2 and match the number (203, 204, or 205). If it matches both
988881 and 203 then bring cell c2 over, if it doesn't then ignore and go to
d2, if it doesn't again go to f2. Once it finds a match in one of those 3
cells, pull the data from the following cell C2, E2 or G2.


1st File
A2 B2
988881 204

2nd File
A2 B2 C2 D2 E2 F2 G2
988881 203 .444 204 1.25 205 .85

Thanks in advance for any help!
--
Baltimore Ravens
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing cells with text to cells with numeric values. David B Microsoft Excel Programming 1 25th Apr 2008 08:05 PM
Comparing 2 cells using vlookup =?Utf-8?B?UmF2ZW5zIEZhbg==?= Microsoft Excel Misc 4 19th Nov 2007 10:27 PM
comparing 2 files with Vlookup possible? dindigul Microsoft Excel Discussion 1 25th May 2007 05:04 PM
VLookup comparing two sheets..please Bonny Microsoft Excel Worksheet Functions 2 16th Sep 2004 01:11 PM
Comparing values using VLookup Richard Foster Microsoft Excel Worksheet Functions 3 24th Dec 2003 02:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:44 PM.