SOLVED

Update Excel Formula

Contributor

Hi,

 

Please assist in updating the formula as explained in the attached file.

My request is to update the INDEX formula to check other criteria.

7 Replies
best response confirmed by A_SIRAT (Contributor)
Solution

@A_SIRAT 

Here is a solution using array formulas; it should work in all versions of Excel. The helper columns aren't needed.

If you have Microsoft 365 or Office 2021, the formulas could be simplified using the new FILTER function.

@A_SIRAT 

Any reason why to use formulas?

 

Change your list into an Excel table (CTRL-T).

Use the column filters or insert slicers für "Client Name" and "Order nr." and filter on them.

 

This was just a sample data and not the entire file.. The formula will help me in pulling data from the Main File into the packing List per client. Anyway, I really appreciate your feedback !
thank you Hans.. The array formula has worked as per my expectation.

@Hans Vogelaar 

 

Hi Hans,

I am trying to update the array formula to include another remark as explained in the attached sheet. I am not able to get it right. Please help.

@A_SIRAT 

See the attached version.

thank you again Hans.

Appreciated..