Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup limitations
I have a workbook setup just like this (below) except it has everyday in
2005. When I do a vlookup I have it lookup according to Week # because that is the line with weekly totals of what I need. I can get the lookup to work but only up to Week # 13 and the it just repeats Week 13 over and over again. What might be causing this? Please help! thanks in advance. Week of 1/3/2005 1/3 Mon 1/4 Tue 1/5 Wed 1/6 Thu 1/7 Fri 1/8 Sat 1/9 Sun Week # 1 Week of 1/10/2005 1/10 Mon 1/11 Tue 1/12 Wed 1/13 Thu 1/14 Fri 1/15 Sat 1/16 Sun Week # 2 Week of 1/17/2005 1/17 Mon 1/18 Tue 1/19 Wed 1/20 Thu 1/21 Fri 1/22 Sat 1/23 Sun Week # 3 |
#2
|
|||
|
|||
Hi
Could you please post your exact formula Cheers JulieD "Dahlman" wrote in message ... I have a workbook setup just like this (below) except it has everyday in 2005. When I do a vlookup I have it lookup according to Week # because that is the line with weekly totals of what I need. I can get the lookup to work but only up to Week # 13 and the it just repeats Week 13 over and over again. What might be causing this? Please help! thanks in advance. Week of 1/3/2005 1/3 Mon 1/4 Tue 1/5 Wed 1/6 Thu 1/7 Fri 1/8 Sat 1/9 Sun Week # 1 Week of 1/10/2005 1/10 Mon 1/11 Tue 1/12 Wed 1/13 Thu 1/14 Fri 1/15 Sat 1/16 Sun Week # 2 Week of 1/17/2005 1/17 Mon 1/18 Tue 1/19 Wed 1/20 Thu 1/21 Fri 1/22 Sat 1/23 Sun Week # 3 |
#3
|
|||
|
|||
Without seeing your formula I'm wondering if you are perhaps not using the
optional 4th argument of FALSE or 0 in your VLOOKUP. Assuming your data was in the range B2:C470 with the week # being in Coilumn B and your actual values being in Column C, and the week # that you want to lookup being sat in say F1 cell then based on what you have told us I would expect your formula would be =VLOOKUP(F1,B2:C470,2,0) or =VLOOKUP(F1,B2:C470,2,FALSE) The 4th argument of FALSE or 0 denotes that an EXACT match mnust be found for the week# you are trying to find. Close enough is not good enough, it must be exact. If you don't do this then it will always return a value, but it may not be the right value. Both ways have their uses, but you need top understand the reasons for, and impacts of each Regards Ken....................... "Dahlman" wrote: I have a workbook setup just like this (below) except it has everyday in 2005. When I do a vlookup I have it lookup according to Week # because that is the line with weekly totals of what I need. I can get the lookup to work but only up to Week # 13 and the it just repeats Week 13 over and over again. What might be causing this? Please help! thanks in advance. Week of 1/3/2005 1/3 Mon 1/4 Tue 1/5 Wed 1/6 Thu 1/7 Fri 1/8 Sat 1/9 Sun Week # 1 Week of 1/10/2005 1/10 Mon 1/11 Tue 1/12 Wed 1/13 Thu 1/14 Fri 1/15 Sat 1/16 Sun Week # 2 Week of 1/17/2005 1/17 Mon 1/18 Tue 1/19 Wed 1/20 Thu 1/21 Fri 1/22 Sat 1/23 Sun Week # 3 |
#4
|
|||
|
|||
Do you have an email address where I can send you the file and you can look
at it.....I know that I haven't used the TRUE and FALSE options but I don't see how that would help. "Ken Wright" wrote: Without seeing your formula I'm wondering if you are perhaps not using the optional 4th argument of FALSE or 0 in your VLOOKUP. Assuming your data was in the range B2:C470 with the week # being in Coilumn B and your actual values being in Column C, and the week # that you want to lookup being sat in say F1 cell then based on what you have told us I would expect your formula would be =VLOOKUP(F1,B2:C470,2,0) or =VLOOKUP(F1,B2:C470,2,FALSE) The 4th argument of FALSE or 0 denotes that an EXACT match mnust be found for the week# you are trying to find. Close enough is not good enough, it must be exact. If you don't do this then it will always return a value, but it may not be the right value. Both ways have their uses, but you need top understand the reasons for, and impacts of each Regards Ken....................... "Dahlman" wrote: I have a workbook setup just like this (below) except it has everyday in 2005. When I do a vlookup I have it lookup according to Week # because that is the line with weekly totals of what I need. I can get the lookup to work but only up to Week # 13 and the it just repeats Week 13 over and over again. What might be causing this? Please help! thanks in advance. Week of 1/3/2005 1/3 Mon 1/4 Tue 1/5 Wed 1/6 Thu 1/7 Fri 1/8 Sat 1/9 Sun Week # 1 Week of 1/10/2005 1/10 Mon 1/11 Tue 1/12 Wed 1/13 Thu 1/14 Fri 1/15 Sat 1/16 Sun Week # 2 Week of 1/17/2005 1/17 Mon 1/18 Tue 1/19 Wed 1/20 Thu 1/21 Fri 1/22 Sat 1/23 Sun Week # 3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
Using Cell references in VLookUp | Excel Worksheet Functions | |||
vlookup. | Excel Worksheet Functions |