unsorted lookup

J

j.ruderman

I need a formula, such as lookup, to extract data from an unsorted column. In
this case i'm tring to find the start time for the lunch period.

A B C
random text 7:00a 10:00a
random text 10:00a 12:00p
Lunch 12:00p 1:00p
random text 1:00p 3:00p

=lookup("lunch",A:A,B:B) wont work because A:A is not sorted.

Thanks
 

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

Finding data between blank rows 2
comparing times in excel 2
Rows to table 0
Invalid LOOKUP Function Results 8
Matching times and classes 5
importing text file question 2
INDEX MATCH SMALL 13
summing times 11

Top