I have a spreadsheet that will auto time stamp column N when my technicians enter their initials into column M. The second thing I would like the spreadsheet to do is, when I enter the hours (example: 1.8) into column E "HRS.", have the spreadsheet put the HRS. into the correct Technicians column, based on the initials entered in column M "Tech Up". Examples:

if E4=1.8 it would put 1.8 into G4 because M4=AB

if E6=3.2 it would put 3.2 into J6 because M6=JW

1 Answer 1


Something like this? The ranges are different here but the logic is the same - each cell in your range gets a formula like this (this is cell B2 in the screenshot):


Which checks to see if the value in the Name column is equal to the column heading of the current cell; if so, it adds the value you put in the HRS column, and if not, it stays blank.

enter image description here

  • Let me try this.
    – myanda
    Oct 10, 2012 at 22:58
  • WOOT!!! That is exactly what i was looking for!!! Thx
    – myanda
    Oct 10, 2012 at 23:11
  • @myanda No prob, happy it helps! Oct 10, 2012 at 23:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.