Lookup Blank Cell

  • Thread starter Thread starter KimC
  • Start date Start date
K

KimC

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?
 
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))}
 
Thankyou for you help, however I'm recieving an #NUM! error - what could be
making that happen?
 
Thanks, I got it to work!! I was doing the whole column instead of a range.
 
Do you need your other posting answered or is this part of that solution?
 
I do need the other one answered as well that one is seperate to this one.

Thanks for you help
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel Concatenate with line breaks but ignore blank cells 3
LOOKUP problem with non-sorted vector 3
Lookups? 3
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Having Blank Cells, etc. ? 1
Conditional Formatting - Formulas with IconSets 1

Back
Top