Forum

Hi Anders, below red mark details are ordered pairs. and below given data's is received details this data's we need to auto update in above ...

Hi Sunny Thanks for your explanation. Hi Anders perfectly using this formula and many thanks you for this. Saliha

Hello SunnyKow Exactly i need this formula thanks for you, but i need lookup value b4 & c4 which is you have updated C column only. can you ...

Hi Anders Thanks for your reply, but its showing wrongly opening data's displaying, i have attached for your reference. regards/Saliha

Hi SunnyKow yes it is different i have mistakenly updated, but i have to updated based on "B" column & "C" column opening. Saliha

Hi Anders I stuck in sumproduct formula, but i got exact result from with you, i am very thanks full for your kind support. regards/Saliha

Hi Jessica Summary data's updating in BOE F-column, e.g. F4 arrived qty I have updated 12014 this qty I need to auto update in DATA sheet F-Colu...

Anybody please help to update formula in this attachment

Hi Mynda I am using 2016 office i used this formula which is you given above but showing error.