Ian Bell
asked on
Convert MATCH Formula replace zero
Hi,
I would like a formula modified to replace zero with 99
Please refer to sheet of formula and explanation.
Many thanks
IanModify formula -no-zero.xlsx
I would like a formula modified to replace zero with 99
Please refer to sheet of formula and explanation.
Many thanks
IanModify formula -no-zero.xlsx
or a simple IF function will do:
=IF( INDEX(DFRMDATA!$A2:$KL2,MATCH(F$1,DFRMDATA!$A$1:$KL$1,0)) = 0, 99, INDEX(DFRMDATA!$A2:$KL2,MATCH(F$1,DFRMDATA!$A$1:$KL$1,0)) )
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys for your kind contributions.
I decided on yours Saqib as it appears more compact.
perfect!
Ian
I decided on yours Saqib as it appears more compact.
perfect!
Ian
Kevin