LinkBack URL
About LinkBacks
Hi All,
Can someone help me with this problem?
What I need to get the correct tagging:
1. Central - If the customer number, sales org, DC and DV is existing in the extract. Like the image below.
Capture.JPG
Hi All,
Can someone help me with this problem?
What I need to get the correct tagging:
1. Central - If the customer number, sales org, DC and DV is existing in the extract. Like the image below.
Capture.JPG
try
=IF(ISERROR(INDEX($D$2:$D$11,MATCH(A3&B3&C3&D3,$F$2:$F$11&$G$2:$G$11&$H$2:$H$11&$I$2:$I$11,0))),"","Central")
use
control shift enter toget a array formula {}
{=IF(ISERROR(INDEX($D$2:$D$11,MATCH(A3&B3&C3&D3,$F$2:$F$11&$G$2:$G$11&$H$2:$H$11&$I$2:$I$11,0))),"","Central")}
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi etaf,
This will actually made the file caldulate so it will take longer..
Am searching for a count ifs option.
Is it posible?
Hi geliedee,
Not sure, but is this?
=COUNTIFS($F$3:$F$11,A3,$G$3:$G$11,B3,$H$3:$H$11,C3,$I$3:$I$11,D3)
format the cell as:
"Central";#;;@
Regards,
Khalid
=IF(COUNTIFS($F$3:$F$9,A3,$G$3:$G$9,B3,$H$3:$H$9,C3,$I$3:$I$9,D3)>0,"central","")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks