Jlambert42
New Member
- Joined
- Oct 20, 2016
- Messages
- 6
Hello all and thank you for taking a moment to read over this.
I have a spreadsheet where the date is entered in column B, a vlookup formula in column A then looks at columns AA to AG to return what week that date falls on in column AH. The yellow highlighted cells in A and B columns are the ones returning the errors, but the formula is the same as the other cells in column A. For the life of me, I cannot see why putting in 9/4/2020 is returning Aug Week 5 and not Sep Week 1. I've tried an index/match formula, but it returns a NA, but I may have figured that wrong.
Current vlookup formula - =IF(B10="","",VLOOKUP(B10,$AA$4:$AH$30,8,1))
if I change the 1 to 0, I get NA error.
I've pretty much burned out what braincells I have that are actually working on a Friday, so if anyone has any thoughts where I went sideways on this, I'd appreciate the feedback.
Thank you and have a great weekend!
Jon
I have a spreadsheet where the date is entered in column B, a vlookup formula in column A then looks at columns AA to AG to return what week that date falls on in column AH. The yellow highlighted cells in A and B columns are the ones returning the errors, but the formula is the same as the other cells in column A. For the life of me, I cannot see why putting in 9/4/2020 is returning Aug Week 5 and not Sep Week 1. I've tried an index/match formula, but it returns a NA, but I may have figured that wrong.
Current vlookup formula - =IF(B10="","",VLOOKUP(B10,$AA$4:$AH$30,8,1))
if I change the 1 to 0, I get NA error.
I've pretty much burned out what braincells I have that are actually working on a Friday, so if anyone has any thoughts where I went sideways on this, I'd appreciate the feedback.
Thank you and have a great weekend!
Jon