Help with formula
 

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

Help with formula
 

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

Help with formula
 

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

Help with formula
 

Use the VLOOKUP Formula

=VLOOKUP(400,B23:H1044,7)

"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

Help with formula
 

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

Help with formula
 

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

Thanks,
Pat

"Duke Carey" wrote:

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