MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Align Data in seperate cells?


Posted by Chris M. on January 02, 2002 10:43 AM

I have two tables. They both have dates and events.
How can I list the two tables next to each other and have the dates line up accross the rows? This way I can see which events are in both tables and which are in one but not the other. Any suggestions?


Posted by Scott on January 02, 2002 11:18 AM

VLOOKUP??

Sounds like you might be able to use VLOOKUP, and lookup the date from one table in the other.