Make a list view with multiple columns from single lookup column

[Requirement]

Lets say we have a “company” list with following fields

1. Title
2. Name
3. Phone

We have another list “workers” which has a lookup colum from “company” list.

Now our requirement is that in our “workers” list view, we want to also show Name and Phone column values for our looked up (company) list.

[Solution]

There is a very simple out-of-box solution for our requirement.

When we are creating the new lookup column in our workers list, it would ask us for the list from which we want to lookup (company in our case).

After that we need to specify which column’s value we want to use as lookup value; this will be filled in the drop-down on our worker item’s add/edit form.

Underneath that it would show a list of all columns available in the looked up (company) list.

Select all columns that we want to show (Name and Phone in our example case) and they would each show up on our (worker) list view.

Note: dont think that now you would be asked for values of all these other selected columns when you are creating a new (worker) item. It would only ask for the primary column value (company title in our example). The other selected columns are only for display purpose and fetch values directly from looked-up list item.