Vlookup will not reference a validation/drop down box

G

Guest

Is there a way to use a drop down box as the criteria in vlookup. We have a
list of months and the corresponding days in the month. When someone selects
the month from a drop down list, the appropriate number of days should be
returned from the vlookup. The lookup is returning the wrong number of days
for the selected month.

Example

Drop down validation uses the months in column M. The drop down is in cell
D1.

Vlookup in F1 - VLOOKUP(D1,M8:N19,2)

Col M Col N Rows 8-19
October 21
November 22
December 23
January 21
February 20
March 23
April 21
May 22
June 22
July 21
August 23
September 22

As is, the vlookup returns 20 for July. Is there a way to fix the error.

Thanks
 
D

Dave O

Try changing the formula from VLOOKUP(D1,M8:N19,2) in F1 to
VLOOKUP(D1,$M$8:$N$19,2) Without absolute cell references (the $
signs) the relevant data range changes each time, and skews the output.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down / validation / lookup into the same cell 2
Use word to associate an item in validation drop down list 2
Mapping strings to integers 5
Sort pivot table field (droplist) by month or original data 1
validation drop down list question 1
Data Validation drop-down 5
Data Validation List (Drop Down) Not Showing 2
Excel 2002 : Why VLOOKUP formula does not show blanks or N/A ? 3

Top