WOW! Thanks so much for your reply. I wish I'd done this 7 days ago. Yes, a
full seven days were spent trying to make this work!!! I just tested it and
it seems to work fine.

I really appreciate your solution!

Thanks,
Pat

"JE McGimpsey" wrote:

One way:

=IF(ISNA(MATCH(400,B23:B1044,0)),0,VLOOKUP(400,B23 :H1044,7,FALSE))

In article ,
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