Forum Discussion
Solved
Setting up data for a word merge
Hi All, I've set up a sheet for which a clients information gets entered and this is then merged onto various forms in word. I need to add a company and company relevant details (1 of 4 to c...
I agree with Martin_Weiss that this is a classic VLOOKUP problem. Not that I have used VLOOKUP for many years. I have used XLOOKUP ever since it appeared and before that INDEX/MATCH. Now, a lookup by company as foreign key would be
= XLOOKUP(foreignKey, Table1[company], Table1)There are vastly more complicated formulas available in 365 insider that will return an entire table of foreign key matches as a single array formula, but they are not relevant here.
Hi Daibear
this is a classical situation for a VLOOKUP.
Here is my example:
=VLOOKUP($L2;Sheet2!$A$2:$D$5;2;FALSE)
You just need to adjust the "2" in the formula, which gives to target column number, so it will be 3 for Info2 and 4 for Info3
