Thread: Vlookup using multiple columns

Hi All,

I'm looking to simply find a function that allows me to lookup a certain value in a table of data and return the value in a specific column. So if I looked up the current date, 6/27/2011, it would return the week it is in (26). I dont want to be limited to just the monday column however, as the dates I will be throughout the entire week. Is there an easy way to do this in excel 2007? Any help would be wonderful!

Monday Tuesday Wednesday Thursday Friday Saturday Week
5/2/2011 5/3/2011 5/4/2011 5/5/2011 5/6/2011 5/7/2011 18
5/9/2011 5/10/2011 5/11/2011 5/12/2011 5/13/2011 5/14/2011 19
5/16/2011 5/17/2011 5/18/2011 5/19/2011 5/20/2011 5/21/2011 20
5/23/2011 5/24/2011 5/25/2011 5/26/2011 5/27/2011 5/28/2011 21
5/30/2011 5/31/2011 6/1/2011 6/2/2011 6/3/2011 6/4/2011 22
6/6/2011 6/7/2011 6/8/2011 6/9/2011 6/10/2011 6/11/2011 23
6/13/2011 6/14/2011 6/15/2011 6/16/2011 6/17/2011 6/18/2011 24
6/20/2011 6/21/2011 6/22/2011 6/23/2011 6/24/2011 6/25/2011 25
6/27/2011 6/28/2011 6/29/2011 6/30/2011 7/1/2011 7/2/2011 26
7/4/2011 7/5/2011 7/6/2011 7/7/2011 7/8/2011 7/9/2011 27
7/11/2011 7/12/2011 7/13/2011 7/14/2011 7/15/2011 7/16/2011 28
7/18/2011 7/19/2011 7/20/2011 7/21/2011 7/22/2011 7/23/2011 29
7/25/2011 7/26/2011 7/27/2011 7/28/2011 7/29/2011 7/30/2011 30
8/1/2011 8/2/2011 8/3/2011 8/4/2011 8/5/2011 8/6/2011 31
8/8/2011 8/9/2011 8/10/2011 8/11/2011 8/12/2011 8/13/2011 32
8/15/2011 8/16/2011 8/17/2011 8/18/2011 8/19/2011 8/20/2011 33
8/22/2011 8/23/2011 8/24/2011 8/25/2011 8/26/2011 8/27/2011 34
8/29/2011 8/30/2011 8/31/2011 9/1/2011 9/2/2011 9/3/2011 35
9/5/2011 9/6/2011 9/7/2011 9/8/2011 9/9/2011 9/10/2011 36
9/12/2011 9/13/2011 9/14/2011 9/15/2011 9/16/2011 9/17/2011 37