Multiplication Number Based On Index Number (Default)

[muhammad susanto]

hi all..

how to find formula for this problem

Pemantauan Identifikasi Titik Rawan Gratifikasi Agust 23.xlsx
	D	E	F	G	H
2	name	indeks (default)
3	building	5
4	cars	10
5
6	name	given	desired result
7	building	5	2
8	building	10	4	from (10/5*2)
9	building	20	8	from (20/5*2)
10	building	16	6,4	from(16/5*2)
11	cars	10	2	from(10/10*2)
12	cars	30	6	from(30/10*2)
Sheet1

index number is default (based on name) building or cars
for bulding always multplicate 5 and for cars is 10, my target in col F7 down
for your help, thank in advance
please, don't use helper column
if it's possible, i hope can use If function not Vlookup

.sst

 

[Anonymous1378]

Try this?

Book3
	D	E	F	G
2	name	indeks (default)
3	building	5
4	cars	10
5
6	name	given	desired result
7	building	5	2
8	building	10	4	from (10/5*2)
9	building	20	8	from (20/5*2)
10	building	16	6.4	from(16/5*2)
11	cars	10	2	from(10/10*2)
12	cars	30	6	from(30/10*2)
Sheet1

Cell Formulas
Range	Formula
F7:F12	F7	=E7/XLOOKUP(D7,$D$3:$D$4,$E$3:$E$4)*2

 

[Bosquedeguate]

Or you can use a VLOOKUP to get the same results.

Book1
	A	B	C	D
1	name	indeks (default)
2	building	5
3	cars	10
4
5	name	given	desired result
6	building	5	2
7	building	10	4	from (10/5*2)
8	building	20	8	from (20/5*2)
9	building	16	6.4	from(16/5*2)
10	cars	10	2	from(10/10*2)
11	cars	30	6	from(30/10*2)
Sheet1

Cell Formulas
Range	Formula
C6:C11	C6	=B6/VLOOKUP(A6,$A$2:$B$3,2)*2

 

[muhammad susanto]

hi Bosquedeguate, the name is alphabet i mean
building
cars

if the lookup is not alphabet, the formula not correct well
how to fix it?
sorry, i have use more 1 device, the formulacan work too in Excel 2010

 

[Bosquedeguate]

hi Bosquedeguate, the name is alphabet i mean
building
cars

if the lookup is not alphabet, the formula not correct well
how to fix it?
sorry, i have use more 1 device, the formulacan work too in Excel 2010

I do not understand your question.
Are you getting an error?

 

[muhammad susanto]

yes you're right, if my index change position
name
cars
building
your formula it not fully work

 

[Bosquedeguate]

yes you're right, if my index change position

name
cars
building
your formula it not fully work

add ,false as another (and last) argument to the function
=B6/VLOOKUP(A6,$A$2:$B$3,2,FALSE)*2