x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 187

# Excel Show latest or lookup

I got two tabs in excel:
TAB1 - contains unique record numbers
TAB2 - contains record data.. records are not in order.

In Tab1 I need a formula to show the record number's name and section with the latest date/time.

TAB1
record#   name   section
1             john         2
2             russ         1
3             ed            6
4
5

TAB2
record#   date               time               name    section
1             1/5/2006        9:50 am         david        1
1             1/5/2006        3:10 pm         john          2
1             12/10/2005     11:00 pm       eve           1
2              7/18/2006        2:00 pm       russ          1
2              7/18/2006        8:00 am       bill             2
3              5/15/2006        9:00 am       ken            3
3              5/14/2006        8:00 am       liz              5
3              5/15/2006        9:15 am       ed              6
0
joberl
1 Solution

Commented:
If the table in tab 1 starts at A1 and the table in Tab 2 starts in A1, you need to enter this as an array formula by using CTRL-Shift-Enter after typing the formula.

=MAX(--(A2=Tab2!\$A\$2:\$A\$9)*--(Tab2!\$B\$2:\$B\$9+Tab2!\$C\$2:\$C\$9))

Some other things to be aware of.

The date in column B and Time in Column C need to be in Excel date time values .  Integer for date and decimal for time.

Hope this helps.

Mike
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.