I have a lookup column that shows choices from another list.
For example
My first list contains a column for “office” and a column for “postcode”
In my second list I have a lookup to the first list and show the “office” value but I also want the postcode to be placed into another text column in the second list.
Is there an easy way to retrieve “other” columns from the first into the scond list?
(I’m sure there is!)