Try

=INDEX(H23:H1044,MATCH(400,B23:B1044))

It'll throw an error if it doesn't find the value 400


"Pat" wrote:

My formula is =IF(OR(B23:B1044=400),H ?,0)

I NEED TO HAVE THE FORMULA GIVE ME THE DATA FROM CELL H OF "WHATEVER
ROW" THE "=400" IS ON...

ANY ASSISTANCE WILL BE GREATLY APPRECIATED...I'M ABOUT TO GO NUTS.

THANKS SO MUCH!!
PAT