Jan 20 2022 03:45 PM
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:
Reference table:
Jan 20 2022 04:30 PM
=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?
Jan 20 2022 08:09 PM