HI,

I am trying to make a database which uses validation list.
However I am having problems since some of the texts I need to use has illegal characters like &, -, /, ()
I found this website that explains it http://www.contextures.com/xlDataVal02.html but I am having a hard time to understand the formula
the example given was =INDIRECT(VLOOKUP(A2,NameLookup,2,0))
My question is where 2 and 0 in the formula came from ... I do not think that will be a constant number to use, so what that 2 and 0 refers to?

Thanks