Help with formula

P

Pat

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
 
D

Duke Carey

Try

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

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

Pat

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
 
P

Pat

Thanks for your reply . . I'm keeping this, just in case I hit another brick
wall somewhere down the line . .

Thanks,
Pat
 
Top