Last answered:

28 Jun 2024

Posted on:

26 Jun 2024

0

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)

3 answers ( 0 marked as helpful)
Instructor
Posted on:

27 Jun 2024

1

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

Posted on:

27 Jun 2024

0

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!

Instructor
Posted on:

28 Jun 2024

0

Hey David,

Do you want to share a link to your workbook (dropbox or google drive) so I can take a better look? 

Submit an answer