Help with Conditional Formulas

Hi, welcome to the forum

1st, remove the "" from all of the real numbers in your formula - you generally only use "" when dealing with text. I can see only 1 "number" that needs them (bolded) in your formula...
=IF(C2=70743,1,IF(AND(C2=258974,D2=3),3,IF(AND(C2="060112-9",D2=1),5,IF(AND(C2=258974,D2=2),6,IF(AND(C2=258974,D2=1),7,"false")))))

However, I think I would create a small table for this and then use INDEX/MATCH, something like this...

	J	K	L	M	N
5		1	2	3	4
6	70743
7	258974	7	6	3
8	060112-9	5

You would then use this, to pull out the value...
=IFERROR(INDEX($K$6:$Q$8,MATCH($C2,$J$6:$J$8,0),MATCH($D2,$K$5:$Q$5,0)),FALSE)

This is obviously a small sample of your data that I used, but the principal holds

INDEX/MATCH is not really that scary, once you break it down. You are already familiar with combining formulas to get stuff, and that is no different.

We start with the INDEX function, which will return the value at the intersection of a given row and column...
=index(range, row-number, column-number)

Not so bad huh?

OK, so all we now need to do is determine the row and column to use, and for that, we call on the MATCH() function. This magical lil guy can be used in exactly the same way both vertically (to find the row number) and horizontally (to find the column number)

=MATCH(criteria-to-find,column-range-to-search-in,0) 0 returns exact match
=MATCH(criteria-to-find,row-range-to-search-in,0)

So in my example above....
INDEX($K$6:$Q$8,MATCH($C2,$J$6:$J$8,0),MATCH($D2,$K$5:$Q$5,0))
I have used the range $K$6:$Q$8 as the index range
then to find the row and column...
MATCH($C2,$J$6:$J$8,0) for the row number
and
MATCH($D2,$K$5:$Q$5,0)) for the column number

Finally, I wrapped the whole thing in IFERROR to catch any error that would show up when the data was not found

I hope that helps explain it a bit, if not, shout and I will try again