Hi again
I need to rework this formula.
=IF(OR(N1831="",S1831=""),"",IF(ISNUMBER(MATCH(1,INDEX(('SAP Listing Extract'!B:B=N1831)*('SAP Listing Extract'!D:D=S1831),,),0)),"YES","NO"))
Order file tab contains a list of SKUs ordered by customers. SAP listing column is empty and needs to be populated based on the listing check. One customer is in the order file is listed individually but in the listing file they are seen as one entity.
The columns cannot be moved around.
How can I have a formula that checks whether the customer that orders particular SKUs is listed for trading the SKU in the listing file?
Thank you!
Conditional VLOOKUP
-
- NewLounger
- Posts: 5
- Joined: 11 Oct 2021, 15:25
Conditional VLOOKUP
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional VLOOKUP
Would it be OK to add a table that specifies which company another company is a subsidiary of?
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 5
- Joined: 11 Oct 2021, 15:25
Re: Conditional VLOOKUP
As long as the original table is not modified, we can add a separate table elsewhere.
The listing table belongs to a different team, so its read only.
The listing table belongs to a different team, so its read only.
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional VLOOKUP
See the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 5
- Joined: 11 Oct 2021, 15:25
Re: Conditional VLOOKUP
Thanks,
I'm trying to translate it to our locations. N:N are the listing file customer names, POLUEKTO sheet is located in the order tracker mapping customer parent, and G:G are the SKU IDs in the listing file.
=IF(COUNTIFS('https://test123.sharepoint.com/sites/test/Shared%20Documents/2.%20test%20Activities/1.0%20Activation%20Records%20-%20G2Gs/[1.%20QA%20-%20SKU%20Listings%20Tracker.xlsx?web=1]Listings for Supply 12.08'!$N:$N,VLOOKUP(I2153,POLUEKTO!A:B,2,FALSE),'https://test123.sharepoint.com/sites/test/Shared%20Documents/2.%20test%20Activities/1.0%20Activation%20Records%20-%20G2Gs/[1.%20QA%20-%20SKU%20Listings%20Tracker.xlsx?web=1]Listings for Supply 12.08'!$G:$G,M2153),"YES","NO")
But I am getting an error, somewhere I guess there is a syntax error?
I'm trying to translate it to our locations. N:N are the listing file customer names, POLUEKTO sheet is located in the order tracker mapping customer parent, and G:G are the SKU IDs in the listing file.
=IF(COUNTIFS('https://test123.sharepoint.com/sites/test/Shared%20Documents/2.%20test%20Activities/1.0%20Activation%20Records%20-%20G2Gs/[1.%20QA%20-%20SKU%20Listings%20Tracker.xlsx?web=1]Listings for Supply 12.08'!$N:$N,VLOOKUP(I2153,POLUEKTO!A:B,2,FALSE),'https://test123.sharepoint.com/sites/test/Shared%20Documents/2.%20test%20Activities/1.0%20Activation%20Records%20-%20G2Gs/[1.%20QA%20-%20SKU%20Listings%20Tracker.xlsx?web=1]Listings for Supply 12.08'!$G:$G,M2153),"YES","NO")
But I am getting an error, somewhere I guess there is a syntax error?
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional VLOOKUP
I'm afraid I don't have any experience with Sharepoint, so I hope that someone else can help you with this.
Best wishes,
Hans
Hans