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