Look Up Col A in a Range and Return Value Adjacent to Looked Up Value

Hello,

I have been searching the posts for an answer to this but the answers I have found dont seem to work.

I need to search a range for a value in a cell.

I was using the following which was working perfectly for me but now I need to return the value to the right of the value found in the range.

=IF(ISERROR(MATCH(A2,$i$2:$i$389,0)),"N",A2)

Here is how i talk through my problem:

If value in A2 is in range I2 to I 1200
return (matching value found in I-range and adjacent value in H column 'preferably just H col val')


I think I have attached an example

Dang! Thank You Sir!

Took me a second but it finally sank in what was happening here.

Thanks again!