trekker1218
Board Regular
- Joined
- Feb 15, 2018
- Messages
- 86
- Office Version
- 2019
- Platform
- Windows
I have read most of the other threads and I have used index and match many times with multiple searches.
I am looking to insert cell data from a second sheet into sheet 1 but only if meets a double verification of matching cells.
I've been using this and getting an error.
=INDEX('orig-data'!Z:Z,MATCH(1,(U19548='orig-data'!O:O)*(AE19548='orig-data'!Y:Y),0))
I want to index a COL on (Orig-Data) sheet. But only show the result of the index if 2 matches are true.
I am looking to insert cell data from a second sheet into sheet 1 but only if meets a double verification of matching cells.
I've been using this and getting an error.
=INDEX('orig-data'!Z:Z,MATCH(1,(U19548='orig-data'!O:O)*(AE19548='orig-data'!Y:Y),0))
I want to index a COL on (Orig-Data) sheet. But only show the result of the index if 2 matches are true.