PivotTable? Or VLOOKUP sheet?

[Tyler_Durden]

I thought I had this finished up, but then I realized this morning (blame it on Friday afternoon attentiveness) that on the final pivot sheet I still need the accounts listed even if the data is blank. For example with the attached sheet. If you choose the TICKER ADM, Account #5 is missing information on the pivot table, which I guess is correct since Account #5 doesn’t hold that security. However is there a way to make the Accounts static, or always shown even if the security isn’t held?

Also if this isn’t doable, could someone point me in a better direction? I basically want a matrix style report that when the user puts in a ticker (either drop down or input box), it will give me all the accounts, and the market value % for each. I can get all the accounts, market value, tickers associated with that market value, but I don’t know how to do the input box or matrix style report, that’s why I choose a pivot table.

This was my thinking about the input box… A user would type in a ticker, then it would bring the Cusip associated with that ticker across the rows starting in B2 Column. Then a simple VLOOKUP would take that cusip and look for the accounts associated with that Cusip. Finally, I would search for #N/A (since some accounts will not have the cusip) and replace it with 0’s. This is basically all I want to do, but am not sure if its possible to do with the vlookup going horizontally?