monthly bills calulation as master file& saperate files by vendor, by income tax head

hi everyone,
i m planning to create a master which contain monthly bills salary & perks details with tax (TDS) calculation.
i have create a dropdown list with vendor name.
now i want to automate fill the tax head after selecting the option from dropdown form vendor name. (FILE ATTACHED)
like if i select courier/triveni sec/ royal sec/ generator in column IT HEAD IT MUST BE 94C
FOR SALARY- 92B
FOR BUILDING RENT- 94I.
AFTER THAT I ALSO WANT SEPARATE FILE FOR VENDORS.

PLZZ SUGGEST THE SOLUTION FOR THAT

You need to place a VLOOKUP formula in your IT HEAD column

=VLOOKUP(A2,'LIST DROPDOWN'!$A$2:$B$8,2,FALSE)

You can then copy this down into other rows

I'm not sure what you mean by a separate file for Vendors. Can you give some more information?

Thanks shirleyxls by vendor list mean that there should be separate sheet for whole year payment for everyone. ie how much we paid for generator in the year, for salary, courier, & i also required a sheet by it head wise, as how much we paid in particular head in the year.
Plz suggest.

There's not really enough data in your sample sheet, but based on what I can see I think this would be possible with a Pivot table.

Could I suggest that, once you have filled in more information on Sheet 2, you post a new question if you don't figure out how to do that?

It should be something like this

Does the summary data have to be on separate tabs? If not, I'd suggest a Pivot table based on the data you entered on the BILLS tab. You can put this on a separate tab and it will be able to summarise all the data by bill type, month, etc. It's the easiest way to analyse things. If you haven't done pivot tables before, do a Google search for Excel Pivot table tutorials. There are some really good resources which will walk you through each step.

If you absolutely need to have separate tabs, I think this would be best achieved using VBA as you will need to read through all the rows on your BILLS tab and output them to various other tabs depending on bill types and IT Heads - or at least that's how it looks to me.