Offset Function based on drop down validation menu

JeffreyWeir

Super Moderator
Staff member
Joined
Mar 22, 2011
Messages
357
Reaction score
0
Points
0
Location
New Zealand
THe problem is the $A$2:$A$8 bit: you need to expand it to cover TO6. i.e. from MATCH($D$5,'Value History'!$A$2:$A$8,0) to MATCH($D$5,'Value History'!$A$2:$A$15,0)
 
Top