Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 cells using vlookup
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing cells when they are not exactly the same | Excel Discussion (Misc queries) | |||
comparing two spreadsheets using vlookup and compare | Excel Worksheet Functions | |||
comparing cells | Excel Worksheet Functions | |||
Comparing Cells | Excel Worksheet Functions | |||
Vlookup - Comparing two lists in different worksheets | Excel Worksheet Functions |