Thread: Vlookup will not reference a validation/drop down box
View Single Post
  #3   Report Post  
Dave O
 
Posts: n/a
Default
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.

Reply With QuoteReply With Quote