Is there an alternate for multiple embedded if statements

[CPD-CB]

Hi There,

I am developing a spreadsheet where I have equations that I would like to refer to cost value out of a matrix (refer to the attached spreadsheet) based on the competency/skill (Skill1, Skill2...) and the level of the person (L1, L2, L3, L4). I know I could do it with multiple IF statements.

I was wondering if there is a way to refer into the (with Skill and Level) matrix rather than having multiple if statements.

Thanks

[zeddy]

Hi

You can use a combination of Offset and Match to do what you want.
see attached file

zeddy

[WebGenii]

Also, with your layout a hlookup would work well.