Conditional VLOOKUP

elgobuda
NewLounger
Posts: 5
Joined: 11 Oct 2021, 15:25

Conditional VLOOKUP

Post by elgobuda »

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!
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional VLOOKUP

Post by HansV »

Would it be OK to add a table that specifies which company another company is a subsidiary of?
Best wishes,
Hans

elgobuda
NewLounger
Posts: 5
Joined: 11 Oct 2021, 15:25

Re: Conditional VLOOKUP

Post by elgobuda »

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.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional VLOOKUP

Post by HansV »

See the attached version.

elgobuda.xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

elgobuda
NewLounger
Posts: 5
Joined: 11 Oct 2021, 15:25

Re: Conditional VLOOKUP

Post by elgobuda »

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?

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional VLOOKUP

Post by HansV »

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