I have a spreadsheet with a summary page containing a selection list for week and a selection list for the portfolio. The workbook has the portfolio data on separate tabs. What I require is data for specific weeks from different portfolio tabs to be brought into a cell in the summary sheet.

E.G. Total Budget for week 32 on Portfolio 3

Currently I can do a VLOOKUP to bring the data back based on the week being selected in the drop down, but I need to have the logic to also look at the correct data tab for the right portfolio data.

What I've tried below (that is not currently working) is:

```
=IF(C4="Portfolio 3",VLOOKUP(C3,'Portfolio 3'!D:E,2,IF(C4="Portfolio 4",VLOOKUP(C3,'Portfolio 4'!D:E,2,IF(C4="Portfolio 2",VLOOKUP(C3,'Portfolio 4'!D:E,2,FALSE))))))
```

`C3`

contains,`Week number`

or what? And one more are you looking for`Total (Sum) of Week 32`

for`Portfolio 3`

in all Sheets?Cont,,,if so then you have two Criteria,, 1. is Week Nu & 2nd is Portfolio 3,, write!!1more comment