For your second question, it sounds like you have hh:mm as your lookup value
and mm:ss as your table, or strings for one, and times for the other - that
will pull up the last value. Try changing the format to number with three or
four decimal places. If they continue to look like times, then they are
strings, and if the values don't match one may be hours and the other
minutes - some may even have days in them...

HTH,
Bernie
MS Excel MVP


"D.Jessup" wrote in message
...
Greetings everyone,

First question, is there anyway to "optimize" this formula:
=IF(J3="","",IF(J3="F",0,IF(J3="P",60,IF(J3<AU$6,1 00,IF(E3="M",IF(ISERROR(VLOOKUP(J3,'Male
Tables'!$AJ$4:AT$140,AR3)),"",VLOOKUP(J3,'Male
Tables'!$AJ$4:AT$140,AR3)),IF(ISERROR(VLOOKUP(J3,' Female
Tables'!$AH$4:AR$140,AR3)),"",VLOOKUP(J3,'Female
Tables'!$AH$4:AR$140,AR3)))))))

Second question, my first column is a time assending column split every 6
seconds, my vlookup works as Microsoft has it, but I need to know how to
do
this...

time value1 value2 value3
12:54 100 100 100
13:00 99 100 100
13:06 98 99 100
13:12 97 98 99

so if the time I'm searching for turns out to be 13:05 (not doing exact
match here) based off of value 3, it will default to pulling up the 13:12
time of "99" when I actually need it to pull up the "100" in value3, is
there
anyway to tell the vlookup not to go to the next value and read the first
value it finds? I hope I made sense of this.

Very Respectfully
--
Just an ordinary Joe