How to match on null cells

  • Thread starter Thread starter Nick Danger
  • Start date Start date
N

Nick Danger

I want to look up a value in one column of my worksheet in another
worksheet, using the MATCH() function. In some rows, this column is empty.
For this case, I want to use a default value, so I extended the range of the
lookup table by one row, assuming that the null cell being compared would
match the null cell in the new last line of the lookup range. Does anyone
know if there is a way to do this without resorting to IF() or replacing all
the null cells with some other placeholder value?
 
Sorry.

The instructions should have been:

=INDEX(B1:B10,MATCH(TRUE,A1:A10="",0))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can only use the whole column in xl2007.
 
Back
Top