Simple one.

[DanielBellfield]

I have a spreadsheet that I want to look up a certain row that is determined by a match formula in column 'A' but the information/price is in column 'C' any ideas of how i can get it to display the value to the right in 'H'?


A................B............C...........D...........E..........F...........G...........H

[TABLE="width: 512"]
<tbody>[TR]
[TD="class: xl63, width: 64"]Code[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]Price[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1001[/TD]
[TD][/TD]
[TD="align: right"]15.48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1002[/TD]
[TD][/TD]
[TD="align: right"]24.48[/TD]
[TD][/TD]
[TD][/TD]
[TD]Row[/TD]
[TD][/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD="align: right"]1003[/TD]
[TD][/TD]
[TD="align: right"]87.68[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]36[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1011[/TD]
[TD][/TD]
[TD="align: right"]33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1013[/TD]
[TD][/TD]
[TD="align: right"]43.4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1015[/TD]
[TD][/TD]
[TD="align: right"]105.68[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1020[/TD]
[TD][/TD]
[TD="align: right"]35.08[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1021[/TD]
[TD][/TD]
[TD="align: right"]63.76[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1022[/TD]
[TD][/TD]
[TD="align: right"]290[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1023[/TD]
[TD][/TD]
[TD="align: right"]290[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1210[/TD]
[TD][/TD]
[TD="align: right"]7.7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1211[/TD]
[TD][/TD]
[TD="align: right"]8.16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1212[/TD]
[TD][/TD]
[TD="align: right"]8.5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Robert Mika]

if you are looking at 36 row in the price column:

Excel 2010
	A	B	C	D	E	F	G	H
1	Code		Price
2
3	1001		15.48
4	1002		24.48			Row		Price
5	1003		87.68			36		175.5
6	1011		33
7	1013		43.4
8	1015		105.68
9	1020		35.08
10	1021		63.76
11	1022		290
12	1023		290
13	1210		7.7
33			134.5
34			141.5
35			148.5
36			157.5
37			166.5
38			175.5
39			184.5
40			193.5
41			202.5
42			211.5
43			220.5
Sheet4

Cell Formulas
Range	Formula
H5	=INDEX($C$3:$C$46,F5)

 

[DanielBellfield]

Cheers Thank you!