IF & then formulas in different worksheets and workbooks
 

Excel 2003 dilema. Worksheet one needs a formula that will pull the contents
of a cell in worksheet 2 AND a separate workbook. The contents of the cell in
worksheet 2 will vary thus changing the result of that cell in worksheet 1.
Example - =if(worksheet2cellb2=a,"separateworkbookcella1")*I F(worksheet2
cellb2=b,"separateworkbook cella2") etc. I will need up to 6 different
variables. The final result needs to be the content of the separate workbook.