Related:
- How can I filter data from two work sheets by matching values
- Tmobile data check - Guide
- Sheets right to left - Guide
- Safe search filter - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
1 response
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.
