I am trying to use a cell that is already defined as a percentage and converting it to a decimal instead of adding another column of cells for a vlookup calculation:
k2:k21 are defined as xx.x% in column 11. I am trying the following with any result:
=IFERROR(VLOOKUP($A$3,'Company Info'!$A$1:$L$25,11,FALSE)/100/A15,0)
when I define l2:l21 as x.xx, I get the expected results:
=IFERROR(A15/VLOOKUP($A$3,'Company Info'!$A$1:$L$25,12,FALSE),0)
Is there a way to use one vlookup to get my expected result, without creating a new column in decimal format?
k2:k21 are defined as xx.x% in column 11. I am trying the following with any result:
=IFERROR(VLOOKUP($A$3,'Company Info'!$A$1:$L$25,11,FALSE)/100/A15,0)
when I define l2:l21 as x.xx, I get the expected results:
=IFERROR(A15/VLOOKUP($A$3,'Company Info'!$A$1:$L$25,12,FALSE),0)
Is there a way to use one vlookup to get my expected result, without creating a new column in decimal format?
