Auto Populate a unit amount into # of hours

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3067796%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EAuto%20Populate%20a%20unit%20amount%20into%20%23%20of%20hours%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3067796%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EAny%20ideas%20on%20an%20equation%20to%20auto%20populate%20%23%20of%20hours%20based%20on%20rate%20type%20and%20%23%20of%20units%3F%20However%20if%20its%20hourly%2C%20I%20would%20need%20the%20hourly%20to%20stay%20the%20same%20and%20populate%20if%20I%20am%20to%20drag%20the%20formula%20to%20populate%20the%20column.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ESpreadsheet%3A%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F341249i00CC7F8A6B806102%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22MYbarra_0-1642722111757.png%22%20alt%3D%22%5C%26quot%3BMYbarra_0-1642722111757.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EReference%20table%3A%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F341250i019A691C15E08628%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22MYbarra_1-1642722215142.png%22%20alt%3D%22%5C%26quot%3BMYbarra_1-1642722215142.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3067796%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EOffice%20365%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

Any ideas on an equation to auto populate # of hours based on rate type and # of units? However if its hourly, I would need the hourly to stay the same and populate if I am to drag the formula to populate the column. 

Spreadsheet:

MYbarra_0-1642722111757.png

Reference table:

MYbarra_1-1642722215142.png

 

2 Replies

@MYbarra 

=IF(VLOOKUP(A2,$A$17:$B$22,2,FALSE)="varies","varies",VLOOKUP(A2&B2,CHOOSE({1,2},$A$17:$A$22&$B$17:$B$22,$C$17:$C$22),2,0))

 

Is this what you are looking for?

I'll see if I can make sense of that formula within my Excel sheet and let you know. It's definitely possible but I have never used the vlookup formula and need to determine how many data point would be required for it to work properly.