Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I think VLOOKUP() isn't proper to do in data validity.

Try: INDEX($B$1:$IV$4;MATCH(A8;$A$1:$A$4;0))

to select the list of values $B$1:$IV$4 in the row in which A8 is located.