Complicated IF's

[taken]

Don't know if there's a better way of doing this.
Thus nested if-statements has a max value of seven and I'm afraid that this code will be more then that.

Making a sheet of points depending on what a seller has sold.
I've got VLOOKUP-functions fetching data adding points to specific articles.

My problems comes when one article has different scores depending on who sold it.
Therefore I need to make an if-statement looking for the value 1 and 2 and making a VLOOKUP to 1 or 2's specific score sheet.

I really don't know how to solve this one.
Probably it's easier if someone just looks at the file, but there's no possibility to upload it here.

I've got this so far:
=IF(H:H=1&L:L=2;VLOOKUP(C:C;PointsFTG!A:E;4;FALSE);VLOOKUP(C:C;PointsPrivat!A:E;4;FALSE))

Don't know if it's possible to have that beginning in the IF-statement.

Is there any Excel expert out there willing to help me with this?
Thanks!
/ Martin

 

[markmzz]

Good explaination.. thanks! =)

You are welcome.

Markmzz

 

[markmzz]

To be more specific..

The article number starts with a H and can change after the H but it always has a space after it.

So, if the each seller has sold more then 6 of this article (which is a few). Then this total point should be added to the sellers total point.
I just see a looooong if-statement doing this. But, probably you guys got a solution that is so much shorter! =)

Would be so greatful if you could help out.

My code for the pID looks like this right now.

[COLOR=#333333]=IF($E2<=-1;VLOOKUP($C2;IF($H2*$L2=1;PointsPrivat!A:E;PointsFTG!A:E);4;0)*$E2;IF($E2>=1;VLOOKUP($C2;IF($H2*$L2=1;PointsPrivat!A:E;PointsFTG!A:E);4;0)*$E2;))[/COLOR]

I'm sorry, but I didn't understand.

Could you post a small example (what you have and what you want)?

Note: with all sheets (Main, PointsPrivat, PointsFTG, etc...).

Markmzz