Have used a vlookup formula to assign entry in column of cells -salary for each employee. When I try to add the values in the cells- it won't do it. Therefore, I can not add up all the employees wages to get a total.
Is this a product of the vlookup?
Also, in this example can I substitute "$40,000" to a value in a specific cell like "A15" ?
=vlookup(a1:a7,{1,"A15"},2) * where A15 is the value in cell A15
Thanks- Andy
Is this a product of the vlookup?
Also, in this example can I substitute "$40,000" to a value in a specific cell like "A15" ?
=vlookup(a1:a7,{1,"A15"},2) * where A15 is the value in cell A15
Thanks- Andy