Lookup_vector

  • Thread starter Thread starter Tarig
  • Start date Start date
T

Tarig

Hi,

What shall I do to make lookup leaves the cell without a match as blank and
not doublicating the value of the last matched cell?
 
You did not specify details on your lookup, but here are a couple of ideas

If you only want to use exact matches you could just check for an exact
match first and if not found use "" like this

If(iserror(match("A",A1:A20,0)),"",Lookup("A",A1:20))
This works for numbers and text


If you are using numbers and only want to return blank if the number is
greater than the last number use this

if(300>max(A1:A20),"",Lookup(300,a1:a20))
This does not work for text.
 
Back
Top