Related:
- How can I filter data from two work sheets by matching values
- Transfer data from one excel worksheet to another automatically - Guide
- Digital data transmission - Guide
- Filter unknown senders - Guide
- Spotify filter liked songs by genre - Guide
- Safe search filter - Guide
1 reply
To get the Name, use:
To get the Address, use:
Important: Each formula MUST be entered by Ctrl-Shift-Enter as this is an Array Formula.
=IFERROR(INDEX(Sheet2!$B$2:$B$6,MATCH($A2&$B2&$C2,Sheet2!$A$2:$A$6&Sheet2!$C$2:$C$6&Sheet2!$D$2:$D$6,0)),"")
To get the Address, use:
=IFERROR(INDEX(Sheet2!$E$2:$E$6,MATCH($A2&$B2&$C2,Sheet2!$A$2:$A$6&Sheet2!$C$2:$C$6&Sheet2!$D$2:$D$6,0)),"")
Important: Each formula MUST be entered by Ctrl-Shift-Enter as this is an Array Formula.