lookup value

[Anonymous]

How i can do to have the same value "C" also in the second row?

TAB 1		TAB 1
A	B	C		A	B	C
2	C	AB		2	C	AB
2		AB		2	C	AB

[edhans · Accepted solution]

You have to have a null value where you want the C. 

1. If it already shows null skip this step. Otherwise, right-click on column2 as shown below, and select Replace Values. You need to either replace empty, which means leave it empty, or a space, and replace it with the word "null" in lower case. It will not put the text "null" there, but will cause the field to be null.
2. Right-click on column 2 and Fill, then Down.