# Need to fill a cell using SUMIF but searching a cell using VLOOKUP

1. ## Need to fill a cell using SUMIF but searching a cell using VLOOKUP

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!!

2. ## Re: Need to fill a cell using SUMIF but searching a cell using VLOOKUP

why are you hand entering the value you are summing in that sumif formula like this... =SUMIF(MASTER!C4:C1000,"*6105.011*",MASTER!H4:H1000)
why not just point it to B3 like this... =SUMIF(MASTER!C4:C1000,B3,MASTER!H4:H1000)?

3. ## Re: Need to fill a cell using SUMIF but searching a cell using VLOOKUP

Hey Sambo kid, this seems to resolve my problem!

Thanks so much for the quick and amazing response!

4. ## Re: Need to fill a cell using SUMIF but searching a cell using VLOOKUP

Glad I could help, AND thank you for the rep! 🙂

There are currently 1 users browsing this thread. (0 members and 1 guests)