Wrong Position?
I keep getting the columns for March - June instead of May - August. The number are correct by why are they offset to the left?
Using : =VLOOKUP($B21,$B$5:$N$10,COLUMNS($G5:J5),FALSE)
Hi David,
Good to hear from you!
The issue you're encountering with the VLOOKUP formula is due to the way the COLUMNS function calculates the column index. The formula you provided is using COLUMNS($G5:J5), which counts the number of columns in the range $G5 to $J5. This count starts from 1 and increments as you expand the range.
Given your requirement for May to August, it seems like the formula needs to be adjusted to align correctly with the desired columns.
=VLOOKUP($B21,$B$5:$N$10,COLUMNS($E5:H5),FALSE)
Hope this helps!
Best,
Ned
Hey Ned, Thank you for the answer.
I'm still getting 64 for the month of May though, after I copied and Pasted your response!
Hey David,
Do you want to share a link to your workbook (dropbox or google drive) so I can take a better look?