Google Sheets – How to Copy Data Based on Initials in Google Sheets

formulasgoogle sheets

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

Best Answer

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):

=IF($E2=B$1,$A2,"")

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

Related Topic