INDEX/MATCH
Help please ! I need to scan left and right in another worksheet to look up a number value but the lines concerned use the same reference number, but with a different subset number. How to look up Number Value with a condition, so that this subset number is taken into account, otherwise returns the same value for all 3 lines??
Example
Reference subset number value (to be retrieved from another worksheet)
60002 0 32.00
60002 1 968.00
60002 5 180.00
Help please ! I need to scan left and right in another worksheet to look up a number value but the lines concerned use the same reference number, but with a different subset number. How to look up Number Value with a condition, so that this subset number is taken into account, otherwise returns the same value for all 3 lines??
Example
Reference subset number value (to be retrieved from another worksheet)
60002 0 32.00
60002 1 968.00
60002 5 180.00