Ageing days

General Excel Questions & Answers

Last Post by Philip Treacy 4 years ago

2 Posts

2 Users

0 Reactions

955 Views

RSS

Md Saliha

(@navsal66)

Posts: 136

Estimable Member

Topic starter

Hello Every one

I have attached Ageing days report can any one help me to update formula for E column(Status) & F column (Remarks) which is i always updating manually

based on that Aging in days

regards/Saliha

Posted : 06/02/2022 6:37 am

Philip Treacy

(@philipt)

Posts: 1650

Member Admin

Hi Saliha,

You can use an approximate match VLOOKUP for this - see attached file.

regards

Phil

Posted : 06/02/2022 10:17 pm

26 Forums
7,430 Topics
32.7 K Posts
62 Online
36.9 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed