DROPDOWN Match Value

[desmond_lee]

Hi

Is it possible to have an expressionin the dropdown list (Col A) in SCAN IN Table that is Match to value (Col A) in CODE DROPDOWN table. What I want to achieve here the dropdown reference in Col A (Table SCAN IN) display only match value in Table CODE DROPDOWN. Col A is a unique value

[TeeSee1]

Not very clear what you are trying to accomplish...

You want a dropdown in Col A of SCAN IN table that gets data from Col A of CODE DROPDOWN Table, correct?

But which col of SCAN is used to match which Col of CODE DROPDOWN?

[desmond_lee]

Oops so sorry for not making this clear. In the SCAN IN Table Col A is the dropdown list. The condition is the SCAN IN Table Col A dropdown list MUST Match to that of CODE DROPDOWN Table. 

[TeeSee1]

Couldn't you just use a ref in SCAN IN Cos A to CODE DROPDOWN?