index and multiple match not working.

[trekker1218]

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.

 

[trekker1218]

Hello,
based on the issue above. Is there a formula that can find the matching ROW based on COL (Sku) and then do a HLOOKUP to find the matching Labels and place the Values in the cell.
example:
In NEW SHEET AF2
find and match (new sheet U2 in Orig-Data O:O then do a hlookup for that matching ROW to lookup New Sheet AE2 in Orig-Data ROW to return the 1/2 Hp value.
I hope this makes sense.
any help is greatly appreciated.

 

[Fluff]

As this is significantly different to your op, you need to start a new thread. Thanks