Issue
This sheet i want to fill out and based on the values i choose here, the value in cell G should be copied to the sheet Sittard
The sheet Sittard looks like this
Solution
use in D2:
=ARRAYFORMULA(IFNA(VLOOKUP(A2:A&B2:B&C2:C;
{Inkoop!D2:D&Inkoop!E2:E&Inkoop!F2:F\ Inkoop!G2:G}; 2; 0)))
or in D1:
={"Stukprijs"; ARRAYFORMULA(IFNA(VLOOKUP(A2:A&B2:B&C2:C;
{Inkoop!D2:D&Inkoop!E2:E&Inkoop!F2:F \Inkoop!G2:G}; 2; 0)))}
Answered By - player0 Answer Checked By - Gilberto Lyons (PHPFixing Admin)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.