There are several ways you get rid of this.Įxample #3 – Convert Text Values to Numerical Values using Paste Special Method Nothing to worry I will show you the way to get rid of this such situation. I think you must have encountered this kind of situation when the actual data is coming from different servers. You can say we can convert these numbers from text values to number values, yes we can, but still, we do not get the results.
This seems to be unrealistic at this point in time, isn’t it? One of the common problems in these cases is numbers are stored as text values. We have got an error value of #N/A against all the city codes.
#HOW TO USE VLOOKUP IN EXCEL 2013 FOR DIFFERENT SHEETS CODE#
Let’s apply the VLOOKUP function to extract the Pin Code for each city. The first thing that comes to our mind is the VLOOKUP function yes, you are correct we can fetch the data by applying the VLOOKUP function. In table 2, we have only City Code and based on this we need to extract the Pin code from table 2. In table 1, we have city code and pin code against city code. Example #2 – VLOOKUP Function to Extract the Data This is the scenario in excel when the numbers stored as text values. Let’s apply the SUM formula in cell B5.Īfter applying the formula, we will get the result.Īfter applying the formula, the result is shown below. In Column B, Numerical Values are stored as Numbers, and in Column C, Numbers are stored as text values so we can get the total of the numbers. You can download this VLOOKUP For Text Excel Template here – VLOOKUP For Text Excel Template Example #1 – Numbers Stored as Text Value
0 kommentar(er)
