Help with formula please

[jdhfch]

Hi,

I am trying to get this formula to extract the data from column H, but it is getting the data from column F instead... And I can't figure out why?

{IFERROR(INDEX(Orders!$C$3:$K$10000, SMALL(IF(COUNTIF(A$32, Orders!$C$3:$K$10000)*COUNTIF($C$3, Orders!$D$3:$D$10000), ROW(Orders!$C$3:$K$10000)-MIN(ROW(Orders!$C$3:$K$10000))+1), ROW($D1)), COLUMN($D1)),0)*1}

Please can someone help.... I know it will be easy for someone, sadly not me!

 

[mohadin]

Hi
May be

=IFERROR(INDEX(orders!$C$3:$K$10000, SMALL(IF(COUNTIF(A$32, orders!$C$3:$K$10000)*COUNTIF($C$3, orders!$D$3:$D$10000), ROW(orders!$C$3:$K$10000)-MIN(ROW(orders!$C$3:$K$10000))+1), ROW($F1)), COLUMN($F1)),0)*1

 

[jdhfch]

Hi

Hi
May be

=IFERROR(INDEX(orders!$C$3:$K$10000, SMALL(IF(COUNTIF(A$32, orders!$C$3:$K$10000)*COUNTIF($C$3, orders!$D$3:$D$10000), ROW(orders!$C$3:$K$10000)-MIN(ROW(orders!$C$3:$K$10000))+1), ROW($F1)), COLUMN($F1)),0)*1

May be

=IFERROR(INDEX(orders!$C$3:$K$10000, SMALL(IF(COUNTIF(A$32, orders!$C$3:$K$10000)*COUNTIF($C$3, orders!$D$3:$D$10000), ROW(orders!$C$3:$K$10000)-MIN(ROW(orders!$C$3:$K$10000))+1), ROW($F1)), COLUMN($F1)),0)*1

 

[jdhfch]

Excellent.. thank you very much

 

[mohadin]

You are welcome
And thank you for the feedback
Be happy and safe