I would like to use Vlookup to return a result based upon referencing the same column-index- number in the same cell. I have the below calculation from spreadsheet A:
=IF(A9="","",IF(G6=0,0,(A6*D9)-(A6-G6)*D9))
In the above, A6 is a deposit %
I wouldlike to convert to a Vlookup:
=IF(A9="","",IF($G$3=0,0,VLOOKUP(C3,'Company Info'!$A$1:$M$18,3,FALSE)*D9-(Deposit %-g6)*D9))
In the above, the column-index-number 3 is the deposit %
I WANT TO AVOID A HELPER COLUMN IF POSSIBLE
=IF(A9="","",IF(G6=0,0,(A6*D9)-(A6-G6)*D9))
In the above, A6 is a deposit %
I wouldlike to convert to a Vlookup:
=IF(A9="","",IF($G$3=0,0,VLOOKUP(C3,'Company Info'!$A$1:$M$18,3,FALSE)*D9-(Deposit %-g6)*D9))
In the above, the column-index-number 3 is the deposit %
I WANT TO AVOID A HELPER COLUMN IF POSSIBLE