Lookup Function

[RevJeff]

I am trying to do a Lookup Function to populate some data, but am having an issue. Here is the basic Lookup code I have.

Please Login or Register  to view this content.

It works fine, but if there isn't a match, then it pulls the data above where it would be.

Any thoughts?

Thanks

[martindwilson]

thats what lookup does
from the help files
If the LOOKUP function can't find the lookup_value, the function matches the largest value in lookup_vector that is less than or equal to lookup_value.
what are you trying to do?
=LOOKUP(D29,'drivers number'!B:B) would just return whatever is in d29
do you want to check if d29 is in 'drivers number'!B:B?
then you could use =if(countif( 'drivers number'!B:B,d29),d29,"")
or
=if(isnumber(match(D29,'drivers number'!B:B,0)),d29,"")

[RevJeff]

Here is the whole formula.

Please Login or Register  to view this content.

Basically I am looking up the values in D:D and matching them against B:B from the 'drivers number' tab and then pulling the value of T:T from the 'drivers number' tab.

[martindwilson]

try
=index('drivers number'!T:T,match(d1,'drivers number'!B:B,0))

[RevJeff]

Thanks! That took care if it!