I would greatly appreciate assistance with adding logic to an existing formula.
The following formula is in cell W48.
=XLOOKUP(O48,'FMA TABLE'!A:A,'FMA TABLE'!C:C)
I want to add logic (conditions) to what column is used to map data from when a value is found.
Currently it is always mapping data back from 'FMA TABLE'!C:C
The logic that I want to add is:
If a value is found in O48, then if the value in P48 = “BLACK AND WHITE METER”, then map data back from TABLE'!D:D
If a value is found in O48, then if the value in P48 = “COLOR METER”, then map data back from TABLE'!E:E
If a value is found in O48, then if the value in P48 = “TOTAL METER”, then map data back from TABLE'!C:C
The following formula is in cell W48.
=XLOOKUP(O48,'FMA TABLE'!A:A,'FMA TABLE'!C:C)
I want to add logic (conditions) to what column is used to map data from when a value is found.
Currently it is always mapping data back from 'FMA TABLE'!C:C
The logic that I want to add is:
If a value is found in O48, then if the value in P48 = “BLACK AND WHITE METER”, then map data back from TABLE'!D:D
If a value is found in O48, then if the value in P48 = “COLOR METER”, then map data back from TABLE'!E:E
If a value is found in O48, then if the value in P48 = “TOTAL METER”, then map data back from TABLE'!C:C