VLOOKUP, MATCH, INDEX, OFFSET

[rinnue]

I have a table, PRICETABLE, it consists of 3 columns. We shall say A, B and C. I need to search column B for the reference and then return the data in the adjacent cell in column A. I'm to the point now where the more I mess around with these functions the more confused I'm getting. I thought for sure VLOOKUP with OFFSET would do it. But I can't figure it out.
I've read alot about searching the first column on the left and then returning data from other columns but not searching a middle column.

I need help Please?

 

[Aladin Akyurek]

Using the name PRICETABLE...

=INDEX(PRICETABLE,MATCH(LookupValue,INDEX(PRICETABLE,0,2),0),1)

Using ranges...

=INDEX($A$2:$A$100,MATCH(LookupValue,$B$2:$B$100,0))

 

[rinnue]

Works like a charm. I was back and forth between the lot of them( Index, Match, Lookup, Offset) for about 5hrs. I wanted to figure it out on my own but EVENTUALLY I decided that I killed enough time. It is so nice to get help.

THANKS