Forum Discussion
Merge two tables using formulas only
Hi, I've been doing some Excel exercises recently, but I'm stuck on this one. Is it possible to fill in the table in Sheet1 with information from Sheet2, but without using power query, just formul...
Please try this...
On Sheet1
In B2
=IFERROR(INDEX(Table2[owner],MATCH(Table1[@[Nr]:[Nr]],Table2[[Nr]:[Nr]],0)),"")and then copy it across and down.
Please refer to the attached for more details...