Summary

**RECOMMENDED: Click here to fix Windows errors and optimize system performance**

Table formulas in Excel are an extremely powerful tool and one of the most difficult to master. A single Excel table formula can perform several calculations and replace thousands of common formulas. Yet 90% of Excel users have never used the table functions in their worksheets simply because they are afraid to learn them.

Essentially, a table in Excel is a collection of elements. The elements can be text or numbers and can be in a single row or column or in several rows and columns. A table formula is a formula that can perform several calculations for one or more elements of a table. You can consider a table as a row or column of values, or a combination of rows and columns of values. Table formulas can return either multiple results or a single result.

### Use of alternative table formulas

If the formula was entered incorrectly, the substitution function does not work correctly. Therefore, in this step, we will use a different formula to start the function. For that:

- Open Excel and start the spreadsheet to which you want to apply the formula.
- Click on the cell to which you want to apply the formula.
- Click on the formula bar.
- Enter the following formula and press Enter.

=ArrayFormula(substitute(substitute(substitute(E2:E5&” “,” y “,” Y “),” yes “,” Y “),” Yes “,” Y “))

In this case, “O” is replaced by “Yes”.

**April 2021 Update:**

We now recommend using this tool for your error. Additionally, this tool fixes common computer errors, protects you against file loss, malware, hardware failures and optimizes your PC for maximum performance. You can fix your PC problems quickly and prevent others from happening with this software:

- Step 1 :
**Download PC Repair & Optimizer Tool**(Windows 10, 8, 7, XP, Vista – Microsoft Gold Certified). - Step 2 : Click “
**Start Scan**” to find Windows registry issues that could be causing PC problems. - Step 3 : Click “
**Repair All**” to fix all issues.

You can customize the formula according to your needs, replace “Y” with the letter or word you want to replace and “yes” with the letter or word you want to replace. You can also change the address of the cells accordingly.

### Using the RegExMatch formula

If the above method has not worked for you, it is possible that by approaching the problem from a different perspective it can be solved. Therefore, in this step, we will implement a different formula that uses a different set of commands to do the work. To apply it:

- Open Excel and start the spreadsheet to which you want to apply the formula.
- Click on the cell to which you want to apply the formula.
- Select the formula bar.
- Enter the formula below and press Enter.

=if(REGEXMATCH(E2,”^Yes|yes|Y|y”)=true,”Yes”)

He also replaced “O” with “Yes”.

The values for “Y” and “Yes” can be adapted to your needs.

https://stackoverflow.com/questions/47569464/array-value-not-found-error

**RECOMMENDED: Click here to troubleshoot Windows errors and optimize system performance**

CCNA, Web Developer, PC Troubleshooter

I am a computer enthusiast and a practicing IT Professional. I have years of experience behind me in computer programming, hardware troubleshooting and repair. I specialise in Web Development and Database Design. I also have a CCNA certification for Network Design and Troubleshooting.