Lookup based on column

[dannyok90]

Hi all,

i have a quick one, looking at the attached screenshot in h16 i have MAX looking at e10-f10 returning the highest number.

i want to get the percentage from that column for the line i'm on if that makes sense

Happy friday everyone!

Dan

 

[AhoyNC]

Are you wanting to return 50% because it's in the second column?
If so try:

Book1
	A	B	C	D	E	F	G	H	I
10
11	Cost Center ID	Variation	Description		Client Price	Application %		Total %
12			External Works
13	1		Car Park	49,772.16
14
15	001-01	voo	Barriers/Wheel Stops	9,720.00	10%	50%	60%	2	50%
16	001-02	voo	Preperation Work	21,177.89			0%
17	001-03	voo	SMA Overlay	15,641.47			0%
18	001-04	voo	Demarcation	1,200.00			0%
19	001-05	voo	Man Hole Covers	2,032.80			0%
20	2		Entrance	18,349.20
Sheet1

Cell Formulas
Range	Formula
I15	I15	=INDEX($E$15:$F$15,$H15)

 

[dannyok90]

Are you wanting to return 50% because it's in the second column?
If so try:

Book1
	A	B	C	D	E	F	G	H	I
10
11	Cost Center ID	Variation	Description		Client Price	Application %		Total %
12			External Works
13	1		Car Park	49,772.16
14
15	001-01	voo	Barriers/Wheel Stops	9,720.00	10%	50%	60%	2	50%
16	001-02	voo	Preperation Work	21,177.89			0%
17	001-03	voo	SMA Overlay	15,641.47			0%
18	001-04	voo	Demarcation	1,200.00			0%
19	001-05	voo	Man Hole Covers	2,032.80			0%
20	2		Entrance	18,349.20
Sheet1

Cell Formulas
Range	Formula
I15	I15	=INDEX($E$15:$F$15,$H15)

Thanks AhoyNC.

Yes exactly, basically so when I add a new column, in this case the next one would be 3, it would give me the percentage in that cell on that line. I’m not on my laptop now but I’ll give it a whirl and come back to you

Dan

 

[AhoyNC]

You will need to change the reference columns in the index to match your columns. Also, probably need to remove the absolute references in the INDEX if you are going to copy the formula down.
For 3 columns something like this:
=INDEX($E15:$G15,$H15)

 

[dannyok90]

You will need to change the reference columns in the index to match your columns. Also, probably need to remove the absolute references in the INDEX if you are going to copy the formula down.
For 3 columns something like this:
=INDEX($E15:$G15,$H15)

Just jumped on the laptop and this worked perfectly. thanks AhoyNC! really appreciate it!