An easier lookup formula ?

[johnny52]

I have four columns and five rows.....I have a formula that works, but there must be an easier way

this is what I'm using,maybe it can be condensed. I might want to expand the formula to accommodate more columns, but for now

=IF(M4=N4,O4+P4,IF(M4=N5,O4+P5,IF(M4=N6,O4+P6,IF(M4=N7,O4+P7,IF(M4=N8,O4+P8,"")))))

Thanks for help

 

[Special-K99]

Try this

=IFERROR(O4+INDEX(P4:P8,MATCH(M4,N4:N8,0),1),"")

Expand P4:P8 N4:N8 ranges as required

 

[Marcelo Branco]

Don't understand what you mean by
"I might want to expand the formula to accommodate more columns,.."

Your formula above can be simplified to
=IFERROR(O4+INDEX(P4:P8,MATCH(M4,N4:N8,0)),"")

M.

 

[johnny52]

Worked great (both responses)

much appreciated!

Thanks

 

[Special-K99]

Don't understand what you mean by
"I might want to expand the formula to accommodate more columns,.."

Your formula above can be simplified to
=IFERROR(O4+INDEX(P4:P8,MATCH(M4,N4:N8,0)),"")

M.

Yep I think he meant rows