Help with formula

[Guest]

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

 

[JE McGimpsey]

One way:

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

 

[Guest]

Try

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

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

 

[Guest]

Use the VLOOKUP Formula

=VLOOKUP(400,B23:H1044,7)

 

[Guest]

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

 

[Guest]

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

Thanks,
Pat