2 File If Statements

  • Thread starter Thread starter shawnacker
  • Start date Start date
S

shawnacker

Hi,
I have two files, one is imported each day with new information and th
other is static.

The first file (dynamic) contains three columns of data, (the number o
rows can change each day):

ColumnA ColumnB ColumnC
30 998653 $500.00
30 995639 $820.00
34 992589 $1120.00


The second file contains two columns of static data which will matc
one set of ColumnA and ColumnB (in the previous file). I would lik
match the two files together and when A&B match 1&2 I would like t
place the value from ColumnC on the first file into Column3 on th
second file.

Column1 Column2 Column3
30 998653 (Formula)


I would like to know if anyone would be able to lead me in th
direction as to how I would build the formula in Column3 on the secon
file. I want to believe that multiple if statements are involved, bu
I am not sure how I would do this without writing hundreds of i
statements to search down the many rows in the first file.

Any help would be greatly appreciated.

Thank you,

Shaw
 
Hi
try the following array formula (entered with CTRL+SHIFT+ENTER) in C1
of your second file
=INDEX('[file1.xls]sheet1'!$C$1:$C$1000,MATCH(1,('[file1.xls]sheet1'!$A
$1:$A$1000=A1)*('[file1.xls]sheet1'!$B$1:$B$1000=B1),0))
copy this formula down for all rows
 
Back
Top