Multiple Lookup from Column

[Bibhuti Mohanty]

Dear Expert,

I need to find the value from multiple lookup column.
For details please find the attached file.


Regards,
Bibhuti

 

[Khalid NGO]

Hi Bibhuti,

Can you please post the expected result with some explanation?

Regards,

 

[Bibhuti Mohanty]

In the details sheet. Amnd Price Column.- we need to find the value as per material No & document date from Amnd Sheet. where the material no should be exact match & the the document date will find in between the date of Effective date from Amnd Sheet.As Example. for material no 10000001,one effective date starts from 01.01.2015 & end on 31.03.2015 & the price is 1.65.
So we need the Amnd Price for the same material will be 1.65 for date starts on 01.01.2015 to 31.03.2015.

Thanks & Regards,

 

[Khalid NGO]

Thanks for the explanation...

Check this in Details sheet, I2:

=SUMIFS(Amnd!$F$3:$F$14,Amnd!$B$3:$B$14,A2,Amnd!$D$3:$D$14,"<="&B2,Amnd!$C$3:$C$14,">="&C2)

copy down as required...

Regards,

 

[Bibhuti Mohanty]

Thanks for your reply.

I need to look up the value on Amnd Price column.but the same formula has sum the value after first effective date.

 

[Khalid NGO]

I need to look up the value on Amnd Price column.but the same formula has sum the value after first effective date.

Not getting your point

 

[J@rv!s]

I am not sure what your are asking for but I did something what I understood. could you check

 

[Bibhuti Mohanty]

sir,
Thanks for your reply.
Please see the attached file i have explain on the J column.

Regards,

 

[Khalid NGO]

Not sure again, but check this:

=SUMIFS(Amnd!$I$3:$I$14,Amnd!$F$3:$F$14,">="&Details!B2,Amnd!$G$3:$G$14,"<="&Details!B2,Amnd!$C$3:$C$14,Details!A2)

Regards,

 

[Bibhuti Mohanty]

Extremely sorry for my bad explanation.
Please go through the modified attached file again for details.

Regards,

 

[Deepak]

Not sure again, but check this:

=SUMIFS(Amnd!$I$3:$I$14,Amnd!$F$3:$F$14,">="&Details!B2,Amnd!$G$3:$G$14,"<="&Details!B2,Amnd!$C$3:$C$14,Details!A2)

Regards,

A little mistake is there!

=SUMIFS(Amnd!$I$3:$I$14,Amnd!$F$3:$F$14,"<="&Details!B2,Amnd!$G$3:$G$14,">="&Details!B2,Amnd!$C$3:$C$14,Details!A2)

It's not your day buddy!

 

[Deepak]

Extremely sorry for my bad explanation.
Please go through the modified attached file again for details.

Regards,

Check this!


=SUMIFS($S$2:$S$15,$M$2:$M$15,A2,$P$2:$P$15,"<="&B2,$Q$2:$Q$15,">="&B2)

 

[Khalid NGO]

It's not your day buddy!

indeed it wasn't

But its new day, new hopes ...

"Each new day is a blank page in the diary of your life. The secret of success is in turning that diary into the best story you possibly can."