|Let's clear up some confusion first:|
If you use the pre tags found above the Comments box, you can line up your data to make it easier for us to read:
A B C
Week Port 1 Port 2
1 1 345 280
2 2 400 560
3 3 367 467
1 Port 1 ____
2 Port 2 ____
Next, you said you have 2 workbooks but your formula looks like you are trying to access data on the same sheet.
What do you have? 2 workbooks? 2 worksheets?
re: I'm trying to create a formula that would automatically update the cells in clumn B of the table in workbook 2...
Update in what manner? In your first table you have multiple values under Port 1 and Port 2.
What are looking to put next to Port 1 and Port 2 in column B of your second table?