Search for Referenced Data

[Frank J]

I'm trying to search for data using a referenced cell and on a different worksheet return the value in the row below in the proper column. On the first worksheet the referenced cell's value is 107, I want to look at the second worksheet and find 107, look across the columns to a specific column and then look down at the row below to find the data in that cell. In the example below the answer would be 79,300. [TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]107
[/TD]
[TD]BJ
[/TD]
[TD]41,000
[/TD]
[TD]25,000
[/TD]
[TD]8,700
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]3,700
[/TD]
[TD]800
[/TD]
[TD]100
[/TD]
[TD]79,300
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Frank J]

Got it to work, my error. Thanks so much for taking so much time to help me.