Hi,
Need formula with multiple conditions.
Excel file attached with necessary details.
Pl. help.
Thanks,
Nagesh.
Hi,
Need formula with multiple conditions.
Excel file attached with necessary details.
Pl. help.
Thanks,
Nagesh.
in F4
=IF(AND(OR(B4="G",B4="B"),C4>=100,C4<=109,ISNUMBER(SEARCH(D4,"PCNF"))<>0,LEFT(L4,1)>="1",LEFT(L4,1)<="4"),E4,"")
and copy down the column
Not sure what you mean about Stage 2 formula (Column G).
Last edited by Special-K; 04-19-2018 at 07:04 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
In F4
Please Login or Register to view this content.
Thank you Special-K & Topley
Seems everything perfect with both the formulas but while checking the condition Sl. No.4, it should check / match the order numbers in Columns A Vs. K and then reference should be entire L column.
Pl. do the needful.
Nothing to do with Stage 2 formula.
I dont understand this, it doesnt say anything about column L in the spreadsheet?
but while checking the condition Sl. No.4, it should check / match the order numbers in Columns A Vs. K and then reference should be entire L column.
Last edited by AliGW; 04-20-2018 at 01:22 AM. Reason: Quote tags added.
Try
=IF(ISNUMBER(LEFT(VLOOKUP(A4,$K$4:$L$29,2,0))+0),IFERROR(IF(AND(OR(B4="B",B4="G"),AND(C4>=100,C4<=109),ISNUMBER(SEARCH("PCNF",D4)),AND(LEFT(VLOOKUP(A4,$K$4:$L$29,2,0))+0>=1,LEFT(VLOOKUP(A4,$K$4:$L$29,2,0))+0<=4)),E4,""),""),"")
OR Special-k's:
=IFERROR(IF(AND(OR(B4="B",B4="G"),AND(C4>=100,C4<=109),ISNUMBER(SEARCH("PCNF",D4)),AND(LEFT(VLOOKUP(A4,$K$4:$L$29,2,0))>="1",LEFT(VLOOKUP(A4,$K$4:$L$29,2,0))<="4")),E4,""),"")
Last edited by JohnTopley; 04-19-2018 at 10:10 AM.
Thanks a Ton Topley. Both the above formulas are working as required.
Will keep working and let you know if i have any issue.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks