Unbrick or Recover Xiaomi Redmi 10A and other MTK devices

Case: Your Redmi 10A (probably other MTK devices too) is not turning on and doesn't react to any button pressed nor cable connection. Requisites:   Dead phone USB Cable  You tried tons of tutorials to unbrick the phone and didn't work This image Willingness to even use Linux to fix it (it's not hard) Steps: Create a bootable USB using the image downloaded. Make sure your computer allows booting from USB. Boot the computer from the bootable USB. When booting, a list of options will be shown. Pick the first one: Boot Live system. Once the system is loaded, go to the right-upper corner to connect to Wi-Fi. Once you have internet, use the Firefox browser (click on the icon in the left-upper corner) and download the Linux version of this tool (SP Flash) and save it in the desktop. Unzip the tool downloaded. Download the fastboot version of the stock ROM . Unzip the ROM, to have the folder and files. Click on 'MTK' icon that is in the desktop. In the command line opene

Making Excel VLOOKUP Function to Work


I have seen many times that there are some scenarios where the Excel VLOOKUP function is not able to calculate the value we are looking for. For example, let's search the amount for the ID 16 according to a little table with this value.

Vlookup not bringing the right value

This is something really easy to do, we need only to use VLOOKUP function selecting the ID, the matrix and the column to be search.

Select the matrix to search on

However, when you see the result of this function you notice that there's an error despite the values are fine.

Error shown in the cell

The reason of this error is that the searched ID value is stored as text, so you can convert it in number in this case because it's only one value, but what if it were a thousand of them?.

Problem on the cell format

To avoid worrying about format issues just embraces the key value in the VALUE function inside the VLOOKUP function.

Use the Value function to get the value of a text

Once you use the function you are going to get the value that corresponds to the ID.

The Vlookup function will work

Consider that this is an example where the VLOOKUP function won't work as we want, I helped many people with this to solve another kind of problems with this function.

Comments

  1. mate, thnx! I like it! That is an extremely essential Excel function and this is very good explanation. You should even do something for the Index Match that does basically the same thing of the VLookup ;)

    ReplyDelete

Post a Comment

Popular posts from this blog

Unbrick or Recover Xiaomi Redmi 10A and other MTK devices

Inserting Rows o Columns in Excel Not Permitted

I Need to Send an Automatic Email with Lotus Notes