| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
