Search on sheet grab cell/reference value to offset

OK I got somewhere at least...

If i use=ADDRESS(MATCH(B8,A1:A5,0),1,4)

A1: Joe B1: Data1
A2: Bob B2: Data2
A3: Ray B3: Data3


B8:Name I want.. for testing lets use RAY.

So when I use the above command it finds RAY and gives me the response A3

I tried using OFFSET, but this is not working..if i use
=Offset(ADDRESS(MATCH(B8,A1:A5,0),1,4),0,1) its supposed to give me the value in B3 its not working.

If i manually type it in the equation =Offset(A3,0,1) then it gives me the contents of B3 like it should.

I am trying to combine this with VLOOKUP to replace/interpret values...DO i have to use a VALUE function to use the function/cells as text.. kinda like VB with Val(TEXTBOX1.TEXT)?????

thanks any assistance would be great

Well I did some more research (actually alot). I noticed ADDRESS can't be used to get information, just returns the address, but can't be used in a forumula to REFERENCe a cell. If you directly type B3 it works.. but using Address/Match to get the B3 won't work in the forumula.

I used..
INDEX(cell range adjacent,MATCH(search text,cellrange to search for text,0)

this actually returned the value
then with vlookup i was able to interpret it.

=VLOOKUP(INDEX(B$1:B$5,MATCH(B7,$A$1:$A$5,0)),{my array for vlookup.},2,0)

I hope this helps someone else.