electronictokwa
Board Regular
- Joined
- Oct 25, 2011
- Messages
- 122
This is just a portion of where I am trying to do vlookup from another sheet. The lookup value is on the first column, and returned value is on the second column. Problem is, I am only getting the result for 1/1/2012, 1/2/2012 down are returning errors.
The VLOOKUP formula from the search tab:
=IFERROR(VLOOKUP(G4,DBList!B6:C370,2,0),"na")
I also used =WEEKNUM(B370,1) & " " & 2012 for the second column below to automatically count the workweek. Any ideas?
<table class="tableizer-table"> <tbody><tr class="tableizer-firstrow"><th>1/1/2012</th><th>1 2012</th><th>January 2012</th></tr> <tr><td>1/2/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/3/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/4/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/5/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/6/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/7/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/8/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/9/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/10/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/11/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/12/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/13/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/14/2012</td><td>2 2012</td><td>January 2012</td></tr></tbody></table>
The VLOOKUP formula from the search tab:
=IFERROR(VLOOKUP(G4,DBList!B6:C370,2,0),"na")
I also used =WEEKNUM(B370,1) & " " & 2012 for the second column below to automatically count the workweek. Any ideas?
<table class="tableizer-table"> <tbody><tr class="tableizer-firstrow"><th>1/1/2012</th><th>1 2012</th><th>January 2012</th></tr> <tr><td>1/2/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/3/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/4/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/5/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/6/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/7/2012</td><td>1 2012</td><td>January 2012</td></tr> <tr><td>1/8/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/9/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/10/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/11/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/12/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/13/2012</td><td>2 2012</td><td>January 2012</td></tr> <tr><td>1/14/2012</td><td>2 2012</td><td>January 2012</td></tr></tbody></table>