| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Blank Cell
I'm wanting to display the value in column A that corresponds with the first
blank cell in column B - what formula do I need to use? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup Blank Cell
Use the Array formula below. Don't type the curly brakckets but type
Shift-Cntl-Enter t make the formula an Arrray formula. {=INDEX(A1:A100,MATCH(1,--(B1:B100=""),0))} "KimC" wrote: I'm wanting to display the value in column A that corresponds with the first blank cell in column B - what formula do I need to use? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup Blank Cell
Thankyou for you help, however I'm recieving an #NUM! error - what could be
making that happen? "Joel" wrote: Use the Array formula below. Don't type the curly brakckets but type Shift-Cntl-Enter t make the formula an Arrray formula. {=INDEX(A1:A100,MATCH(1,--(B1:B100=""),0))} "KimC" wrote: I'm wanting to display the value in column A that corresponds with the first blank cell in column B - what formula do I need to use? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup Blank Cell
Thanks, I got it to work!! I was doing the whole column instead of a range.
"Joel" wrote: Use the Array formula below. Don't type the curly brakckets but type Shift-Cntl-Enter t make the formula an Arrray formula. {=INDEX(A1:A100,MATCH(1,--(B1:B100=""),0))} "KimC" wrote: I'm wanting to display the value in column A that corresponds with the first blank cell in column B - what formula do I need to use? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup Blank Cell
Do you need your other posting answered or is this part of that solution?
"KimC" wrote: Thanks, I got it to work!! I was doing the whole column instead of a range. "Joel" wrote: Use the Array formula below. Don't type the curly brakckets but type Shift-Cntl-Enter t make the formula an Arrray formula. {=INDEX(A1:A100,MATCH(1,--(B1:B100=""),0))} "KimC" wrote: I'm wanting to display the value in column A that corresponds with the first blank cell in column B - what formula do I need to use? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup Blank Cell
I do need the other one answered as well that one is seperate to this one.
Thanks for you help "Joel" wrote: Do you need your other posting answered or is this part of that solution? "KimC" wrote: Thanks, I got it to work!! I was doing the whole column instead of a range. "Joel" wrote: Use the Array formula below. Don't type the curly brakckets but type Shift-Cntl-Enter t make the formula an Arrray formula. {=INDEX(A1:A100,MATCH(1,--(B1:B100=""),0))} "KimC" wrote: I'm wanting to display the value in column A that corresponds with the first blank cell in column B - what formula do I need to use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP returns 0 (zero) when lookup cell is blank | Excel Discussion (Misc queries) | |||
| Retrieving first non-blank cell during a V-LOOKUP | Excel Discussion (Misc queries) | |||
| Lookup based on 1st non-blank cell | Excel Worksheet Functions | |||
| Returning a blank cell rather then #N/A (Lookup) | Excel Discussion (Misc queries) | |||
| Return of blank cell if lookup fails | Excel Worksheet Functions | |||
Hybrid Mode
