I am building a spreadsheet that uses a vlookup in the Master sheet. I have a dropdown to select a department. The department number is then filled in via a vlookup into an adjacent cell. On another sheet, I need that vlookup number to be used as a search for a dollar total.
I have attached the sheet. The PRINT SHEET is where my difficulty comes in. I want column C to auto-sum all matches to column B. Column B numbers are being drawn from MASTER where column C is populated by a VLOOKUP.
Sorry for any confusion in my writing this. Hopefully the sheet will help make sense.
Thanks for any and all assistance!!
Bookmarks