Using the Offset Function

[carl]

I think my question can be handled via the Offset function but not sure...

I have my data table looking like so:

row2 !35 Q !115 CBO !34 1562
row3 !35 Q !34 1576 !72 COB

I am trying to find a formula for b2....b200 below (filled in with the
correct value for this example) that will look at the value in B1, and then
look at the same row in my data table and return the value 1 cell to the
right:

!34
row2 1562
row3 1576


Thank you in advance.

 

[Bob Phillips]

Not sure if the data contains row2 or that is signifying the row?

Anyway assuming the data table is in N2:Ynn, something like

=INDEX(N2:Y2,MATCH($B$1,M2:X2,0))