Using Ref or Vlookup help

I have two tables with Columns as below
TABLE1. Master
COLUMN1 : CODE
COLUMN2 : NAME
COLUMN3 : PHONE

TABLE2. DATA
COLUMN1: CODE

Now when I have given for table 2 for column1 as “ref” type and source as Master

When I select the dropdown option in table 2 for column1 it is automatically showing Column 2 values, i.e Name from Master Table

Hi @Sush1102 is your name column type lable ? Are you still getting the code in your customer code column.

Thanks for your reply. Solved.

1 Like