cell value when cell address is known

[gikis]

Hi,
ok whats what i need:
I have my data in two columns, and I am looking for a data in one column using match function, which gives me row where my data is located. I need to get value that stands in the next column. How to do this?

for examle:

A B

2 5
1 8
3 6
4 2

I match value "1" in column A and getting result "2" , i need that program get me value of the cell in column B at row "2", or in this case "8". How it can be done?

[TMS]

=INDEX(B:B,MATCH(1,A:A,0))


Regards

[ChemistB]

Use INDEX

=INDEX($B$1:$B$10, MATCH(1, $A$1:$A$10,0))
Does that work for you?

[gikis]

Thanks, guys. It works.

[TMS]

You're welcome. Thanks for the rep.