Greetings,
I've the following formula which partially works, but for some reasons, gives me a 0 instead of the expected values.
=IF(D2="STANDARD_RELEASE",Sheet1!D2,Sheet2!B2)
The formula will look in O.Type (column D) of sheet2 to check value is “STANDARD_RELEASE” if so, then it will find the order # in sheet1 and overwrite it with the voucher #.
Otherwise, it will keep the original order #.
TIA,
Regards,
OCM
I've the following formula which partially works, but for some reasons, gives me a 0 instead of the expected values.
=IF(D2="STANDARD_RELEASE",Sheet1!D2,Sheet2!B2)
The formula will look in O.Type (column D) of sheet2 to check value is “STANDARD_RELEASE” if so, then it will find the order # in sheet1 and overwrite it with the voucher #.
Otherwise, it will keep the original order #.
TIA,
Regards,
OCM