INDEX,Match or LOOKUP Function

[Buddhaboy32]

Hi All,

I am busy with a work sheet that gives me the following info using the Index,Match function.

However, I am hitting a brick wall with Rows 6 and 7 in the above image.

Below you can see my spreadsheet

What I wish to accomplish is the following:

If in image 1, where code = FCT-80-1-CER, and my Bar = 3,4 then my L/Min must = 1,00

If I change my "code" in image 1, i.e Code = FCT-80-6-CER, and my "BAR" changes to 6,2 then my "L/Min must = 3,20

So, basically I need the "Code" to stay the same, but be able to change the "BARS" which in turn change the "L/Min".

Example: FCT-80-0,5-CER = 0,56 L/Min @ 3,4 Bars
FCT-80-0,5-CER = 0,84 L/Min @ 9 Bars

FCT-80-4-CER = 2,53 L/Min @ 6,2 Bars
FCT-80-4-CER = 3,00 L/Min @ 9 Bars

NEED HELP PLEASE.

 

[Snakehips]

@Buddhaboy32
Assuming your lookup data to be in Sheet12 range A3:L11 (Edit to suit). then something like the below.

Book1
	B	C	D	E	F	G	H	I	J	K	L
3						3.4	4.8	6.2	7.6	9	10.4
4		Lilac				0.56
5	8259376	White				0.75
6	8259377	Blue	MAG-CH 1	FCT-80-1-CER		1		99
7	8259378	Black	MAG-CH 2	FCT-80-2-CER		1.28
8	8259379	Orange	MAG-CH 3	FCT-80-3-CER		1.5
9	8259380	Red	MAG-CH 4	FCT-80-4-CER		1.94
10	8259381	Green	MAG-CH 5	FCT-80-5-CER		2.13
Sheet12

Book1
	A	B
1	Category
2	Code	FCT-80-1-CER
3	Colour	Blue
4	Type	MAG-CH 1
5	P/N	8259377
6	Bar	3.4
7	L/Min	1
8	Price
Sheet11

Cell Formulas
Range	Formula
B3	B3	=INDEX(Sheet12!$C$3:$C$11,MATCH($B$2,Sheet12!$E$3:$E$11,0),1)
B4	B4	=INDEX(Sheet12!$D$3:$D$11,MATCH($B$2,Sheet12!$E$3:$E$11,0),1)
B5	B5	=INDEX(Sheet12!$B$3:$B$11,MATCH($B$2,Sheet12!$E$3:$E$11,0),1)
B7	B7	=INDEX(Sheet12!$G$3:$L$11,MATCH($B$2,Sheet12!$E$3:$E$11,0),MATCH($B$6,Sheet12!$G$3:$LE$3,0))

Hope that helps.

 

[Buddhaboy32]

Snakehips

The formula worked, thank you so much for you help. Much appreciated.