Hi all,
I'm trying to make a matrix with 1 and 0 based on 3 different tabs in the sheet. Because some data has to be cross checked (at least I think, could be wrong) I just get a brain freeze ;-).
Since I'm not an expert in Excel or Google Sheets I come to you for some help. I made this sheet in Google Sheets, but Excel would be fine as well.
If anyone could help me with this that would be highly appreciated! Or even just get me on my way, would help as well ;-). I tried to make a logical expression first but even there I seem to get stuck.
The wanted outcome
A matrix where there is a 1 or 0 depending on the following rules:
Return the value 1 when;
- the number in column B for the customer in row 1 is not equal to the number of a other customer that also operates in the same land (due to exclusivity) and the number in column A (for the same row) can be found in the quality list for that customer (tab Customer Quality)
There are 3 tabs that contain data;
- Customer-Number —> contains the numbers a client has exclusivity for (only counts in the land he operates)
- Customer-Land —> contains the lands a client operates
- Customer-Quality —> contains the quality the client has rights to
If anyone could help me get to the wanted outcome that would be great!
Kind regards,
Robbert
Bookmarks