I have a numbers file with a first sheet like this:
Then a second sheet that looks like this:
For each row in sheet 1 I need to find if there is a matching SKU on sheet 2 (sheet 1, col N with sheet 2, col B). Then, if there is a match, get Mark down value (Sheet 2, col D) and apply that discount on Sheet 1, col T.
I've been trying with this approach here...
...but didn't get there yet.
Is this possible in Mac Numbers? If possible, what would be the way to achieve it?
Sheets don't have the same records nor rows in the same order so I can't just copy and paste a column to use a formula with relative cell positions.