vlookup of match and index

[zaid999]

So I'll try to keep this simple guys*

Work gives me a spreadsheet that looks like this*

Number number number X Y Z*

Number is the lookup reference and x y z are return values


So I have used v lookups in the past to return x y z but since I have so search 3 columns number* I used to have to copy paste everything into one column recently I have tried match and index and (I'm nit terrible at excel but **** if I can figure this out)

A small example is*

=indez($z: $z,match (v7, $o: $r,0))

Where z is my return *value and O-R are my look up values*

any help would be appreciated*

 

[zaid999]

Or to simplify it even more
How do I write an index and match formula
That searchs $A: $D and returns E on the same row

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=IFERROR(INDEX($Z$2:$Z$100,1/(1/MIN(IF($O$2:$R$100=V7,ROW($Z$2:$Z$100)-ROW($Z$2)+1)))),"not found")

Hope this helps.