Forum Discussion
VLookup Formula
I need to lookup a weekday value (say Sunday) in column 2 then return the average of the "Sunday" values in column 3. Can this also be done by using a cell to type in the number of weeks you wish t...
Many thanks!! I will try this!!
You're welcome!
- This works extremely well!! Just needing to tweak it a bit and I can't seem to get there. I added a 4th column labeled "Include" where I can add an "N" if I don't to include that day's data. I was trying to wrap the formula in an IF statement to first look at the "Include" column for an "N" and if found, ignore that row but it didn't work. Any help you can provide would be greatly appreciate!!