Look up across multiple sheets

  • Thread starter Thread starter confused!!
  • Start date Start date
C

confused!!

i need to look up a list of names across multiple worksheets in two different
workbooks then return the oldest date associated with that name.

How can i do this?
How do i look up the Column A in workbook 1 amongst all the worksheets in
workbook 1 and 2 so to return the latest date in workbook 1 or 2.
example: work book 1 would read
Column A Column B Column C
Look up User ID user ID log on date
Moton Moton 01/01/09
Doe Moton 07/09/09
Flattery Moton 12/09/09

Workbook2 would read
Column A Column B
User ID log on date
Moton 01/01/10
Moton 02/09/10
 
I would do my best to put all the data on one sheet.

If that's impossible, then I would use separate =vlookup() formulas in lots of
different columns. Then look at the results to find the date I wanted.
 

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

rerturn latest date 1
Complex Look Up 4
Complex Look Up (amended) 2
Count based on multiple criteria 2
dates inbetween 3
Need a Function 5
LOOKUP function between two dates in Excel 2007 6
LOOKUP within a 1

Back
Top