Excel formula

[kumar lama]

Is There Short form for this Formula Please, but not VLookup, it's working but very long
=IF(INDEX(Sheet2!E5:E12,MATCH(C5,Sheet2!C5:C12,0))=1,"ABC",IF(INDEX(Sheet2!F5:F12,MATCH(C5,Sheet2!C5:C12,0))=1,"BCD",IF(INDEX(Sheet2!G5:G12,MATCH(C5,Sheet2!C5:C12,0))=1,"EFG","")))

 

[Domenic]

Try...

=INDEX({"ABC","BCD","EFG"},MATCH(1,INDEX(Sheet2!E5:G12,MATCH(C5,Sheet2!C5:C12,0),0),0))

or

=IFERROR(INDEX({"ABC","BCD","EFG"},MATCH(1,INDEX(Sheet2!E5:G12,MATCH(C5,Sheet2!C5:C12,0),0),0)),"")

...which both need to be confirmed with CONTROL+SHIFT+ENTER. Note that the array constant {"ABC","BCD","EFG"} can be replaced with a reference to a range of cells. For example, let E4 contain ABC, let F4 contain BCD, and G4 contain EFG, and then try...

=INDEX(Sheet2!E4:G4,MATCH(1,INDEX(Sheet2!E5:G12,MATCH(C5,Sheet2!C5:C12,0),0),0))

...which also needs to be confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

 

[Domenic]

Actually, these formulas only need to be confirmed with ENTER, not CONTROL+SHIFT+ENTER...

 

[kumar lama]

Thank You it's save my time alot Domenic,

 

[Domenic]

You're very welcome, and thanks for the feedback!