Hello,
I would to create a formula within my excel to return the Range Status (Column C) depending on what value is in Columns A & B without having to manually type these out.
I'm assuming I need to use a IF AND formula, but having a mind blank when I have so many variables to return. Can somebody please help?
Range status formula.xlsx
Last edited by abigailrose; 11-26-2024 at 08:04 AM.
Welcome to the forum.
Which column represents your expected results? I don't understand what you want here.
Is this it?
AliGW on MS365 Beta Channel (Windows 11) 64 bit
Stocked Stocked LFL =FILTER(Table1[Status],(Table1[Stocked This Year]=G2)*(Table1[Stocked Last Year]=H2))
Sheet: Sheet1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Sorry it's not clear. I've added a separate table (A12:E15) which would be an example in a separate version. So I need a formula to determine the status in column E.
A1:C5 is the rules that it would need to follow.
Range status formula v2.xlsx
Just adapt what I suggested above:
=FILTER(Table1[Status],(Table1[Stocked This Year]=[@[Stocked This Year]])*(Table1[Stocked Last Year]=[@[Stocked Last Year]]))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks