Fomulas and Lookups

[TheBanker]

Hi Guys,

I have this fomula in a spread sheet and when I try to add another parameter it is not working, any suggestions?

=SUM(IF(ISNUMBER(MATCH(E14:E18,{"L","T","P","S","RH","SS","LL","PH"},0)),LOOKUP(E14:E18,{"L","T","P","S","RH","SS","LL","PH";1,1,1,1,1,1,1,1})))

 

[VoG]

That looks like an array formula so you need to confirm it using CTRL + Shift + Enter, not just Enter.l

 

[TheBanker]

Thank you, feel slight silly but in my defence dont use them very often