Complex Index Match trouble

**Aquarock** · 02-12-2019, 10:18 AM

Hello,

I've attached a working example of my issue. By changing the MFG Date in Column B, the EOL % recalculates in Column D based on data in Sheet 2, Column E (type field), and the Table beginning on line 10. Lines 3 & 4 are an example showing one I have working, but for some reason now I am struggling to add in a "third criteria" (i.e. if the Column E field = "12V") I need it to operate just like my existing lines do for Column E type of "V" and "F".

As always, any help is greatly appreciated!

**JeteMc** · 02-19-2019, 10:15 AM

The following modification of the formula in D2:D4 may be what you are looking for:

Formula:

=IF(B2<>"",IF(INDEX(VorF,MATCH(A2,BattNames,0))="F",IF(C2<=10,1,1-(0.02*(C2-10))),IF(INDEX(VorF,MATCH(A2,BattNames,0))="12V",1-(C2*0.04),IF(INDEX(Start,MATCH(LEFT(A2,3),MAN,0))>=C2,1,(1 - (C2 - INDEX(Start,MATCH(LEFT(A2,3),MAN,0)))*INDEX(PPY,MATCH(LEFT(A2,3),MAN,0)))))),"")

Let us know if you have any questions.

Complex Index Match trouble

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Complex Index Match trouble

Re: Complex Index Match trouble

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Trouble with Index and Match

trouble with using sum in an index match

[SOLVED] Trouble with Index(match) - I think!

Trouble with Index-Match getting #REF!

complex index match

[SOLVED] INDEX MATCH Trouble

Complex Index Match Help (or at least complex to me)

Bookmarks

Bookmarks

Posting Permissions