I have two workbooks; I want to look up the value in column 2 in one workbook
and put it in column 2 of the other workbook. I am matching the values in
column 1 in each. When I fill down, I get the exact same answer. My auto
calculation is turned on. Here is my formula:
=IF(ISERROR(VLOOKUP(A2,'[Aetna - PPO & Dental Jul
2007.xls]Sheet1'!$A$2:$B$126,2)),"",VLOOKUP(A2,'[Aetna - PPO & Dental Jul
2007.xls]Sheet1'!$A$2:$B$126,2))
Can anyone help?