Need help with nested IF?

[Spain412]

I am working on a formula that does an INDEX and Match depending on whether a cell is "M" or "F".

The following is what I have currently:

=IF(E2="M",(INDEX('Screening Table Weight'!$A$5:$F$28,MATCH(ROUND(H2,0),'Screening Table Weight'!$A$5:$A$28,0),MATCH(G2,'Screening Table Weight'!$A$5:$F$5,1))),IF(E2="F",(INDEX('Screening Table Weight'!$G$5:$K$28,MATCH(ROUND(H2,0),'Screening Table Weight'!$G$5:$K$28,0),MATCH(G2,'Screening Table Weight'!$G$5:$K$5,1)))))

The first criteria, "M" is referencing and working correctly. The "F" is not working correctly. I think that perhaps I should not be using a nested IF, but I do not know what to do from here, or what it should look like. If someone could please offer guidance on this, I would greatly appreciate it.

[Vikas_Gautam]

Try this,
I have corrected this...
if it is not the solution.. then provide a non-sensitive workbook...

Please Login or Register  to view this content.

Say thanks, click *

[Vikas_Gautam]

Try this,
I have corrected this...
if it is not the solution.. then provide a non-sensitive workbook...

Please Login or Register  to view this content.

Say thanks, click *

[Richard Buttrey]

Hi,

Perhaps

Please Login or Register  to view this content.

[Spain412]

The formula, as it was previously entered, works for the "M" but not for the "F". Both solutions Vikas and Richard,also worked for the "M", but not for the "F".

[Spain412]

Disregard. I figured it out. I was referencing the second set incorrectly.

=IF(E3="M",(INDEX('Screening Table Weight'!$A$5:$F$28,MATCH(ROUND(H3,0),'Screening Table Weight'!$A$5:$A$28,0),MATCH(G3,'Screening Table Weight'!$A$5:$F$5,1))),IF(E3="F",(INDEX('Screening Table Weight'!$G$5:$K$28,MATCH(ROUND(H3,0),'Screening Table Weight'!$G$5:$G$28,0),MATCH(G3,'Screening Table Weight'!$G$5:$K$5,1)))))it out. Correction below: