Text in one row auto fills a number of cells

[bellmal]

I have spent a whole day trying to find an answer to this problem and my head now hurts!

I have a work expenditure sheet that I fill in and the problem I would like automated is in column B I enter some text Salary, Mileage, Subsistence etc. this then auto fills 2 cells on the same row with the same number but different amounts depending on the item. This would have to run down over 30 odd rows. So Mileage in B3 would populate E3 and J3 with 15.00 then B4 Subsistence would populate D4 and G4 with 10.00 and Salary with 25.00 (not even minimum wage!!!)

I have fond out a lot about VLOOKUP but don't think this will do the job. Any help would be much appreciated.

Thanks
bellmal

 

[Forever_EX]

What do you mean same number but different amounts? Can you give an example of what this looks like versus what you want it to look like?

You can use formulas and set rules in excel, and quickly drag the tiny corner + sign to fill in multiple cells with the formula.

 

[bellmal]

What do you mean same number but different amounts? Can you give an example of what this looks like versus what you want it to look like?

You can use formulas and set rules in excel, and quickly drag the tiny corner + sign to fill in multiple cells with the formula.

Thanks for showing an interest in my problem.

What I meant was that if I enter Mileage in B2 then this would populate cells E3 and J3 with 15 but if I had entered Salary in B3 it would have filled cells F3 and H3 with 25.

I think I need to create a drop-down list with the various names and which cells to fill and the amounts entered ( I did this once along time ago but then not sure how to transfer that.