teleren/devto huggingface dataset:
Formula to find Vlookup & Return Matching Values from Multiple worksheet
Tags: excelformula, excelformulas
Published: 2020-10-16 11:57:00

---
title: Formula to find Vlookup & Return Matching Values from Multiple worksheet
published: true
date: 2020-10-16 09:45:09 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formula-to-find-vlookup-return-matching-values-from-multiple-worksheet/
---

## Excel Formula to Find Vlookup and Return the Matching Values from Multiple Worksheet:

Here we will discuss how to use Formula to find Vlookup and Return the Matching Values from Multiple Worksheet in Excel Office 365. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)


## Formula Syntax:

- Formula to Return Values from Multiple Worksheets in Excel Office:

**=[IFERROR](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)([VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(Sheer4!A2,[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)({1,0},Sheet1!$A$2:$A$6,Sheet1!$B$2;$B$6),2,[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)),IFERROR(VLOOKUP(Sheet4!A2,IF({1,0},Sheet2!$A$2:$A$6,Sheet2!$B$2:$B$6),2,FALSE),**

### Example:

- In the below screenshot, we give the input id in **Column A**.
- After applying the formula, it will display the output in a selected **Column B**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/cv35.png)

## Explanations for Syntax:

- **IFERROR** – This function is used to returns the custom result when the formula generates an error and it will show the standard results when no error detected. For more details about the [**IFERROR Function**](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/).
- **VLOOKUP** -In Excel, the [**VLOOKUP Function**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/) will lookup data in a range or table by row.
- **IF** -The main purpose of the IF Function is to return one value for a TRUE result, and another one for a FALSE result. Read more on the [**IF Function**](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/).
- **FALSE** – It will return the logical value FALSE. For more details on the **[FALSE Function](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/).**

## Conclusion:

In this tutorial, you can get some clarification on how to use the **formula to return the matching values from multiple worksheets** in Excel Office 365. If you have any **queries,** drop it in the below comment section. Don’t forget to share your valuable feedback. Thank you for visiting **[Geek Excel](https://geekexcel.com/)!!**
My Hactoberfest 2020 experience
Tags: hacktoberfest, opensource, github, firstcontribution
Published: 2020-10-16 09:15:25

So yesterday i succesfully completed the hactoberfest-2020 chalanged organised by [@digitalocean](https://www.digitalocean.com/). I was a noob in the field of open source and this was the first time of me being participating in an open source contribution contest.

For The first few days I didn't have any idea how i am going to complete my 4 pull request as i never did that ,I knew git and github and i was a bit experienced in git but i did not know much about open source. I watched a lot of youtube videos, read a lot of blogs and after all that i finally created my first pull request to one of my friends web development project slowly slowly I started learning things I got introduced to `contributing.md` , and I also learned markdown , I learned somne basic things about the purpose of `.github` folder on github.In a nutshell I learned a lot of things.

And after few days of struggle I got a boom from a guy who never made a pull request I made 7 valid pull requests for hacktoberfest ,looking back I really have to say I learned a lot in  a short period of time and to all the nooobies in open source i would say that get your hands dirty in open source only that way you guys can really start to learn about open source.
after my experience i can say that the  boom you will get from hacktoberfest in the field of open source is unmatched.

[my github](https://github.com/debojeetjha10)
How to shuffle an array in JavaScript
Tags: javascript
Published: 2020-10-16 09:14:27

---
title: How to shuffle an array in JavaScript
published: true
description: In this article we’ll take a look at a couple of ways to shuffle an array in JavaScript.
tags: javascript
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/f4lkplc0vpfo3lnuplpi.jpg
---

In this article we’ll take a look at a couple of ways to shuffle an array in JavaScript.

## Custom sort

The first and simplest way to shuffle an array in JavaScript is to provide a custom function to a `.sort()`.

```javascript
const array = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10];
const shuffledArray = array.sort((a, b) => 0.5 - Math.random());
```

As the function we pass to `.sort()` is looking for either a positive or negative number to either move the item ‘up’ or ‘down’ in the array, each item has a chance of being moved in either direction giving us a shuffled array of items.

This works for a rough-and-ready approach but might not give you a truly random shuffle.

If you do a bit of research in to the above technique (check out [this article](http://www.robweir.com/blog/2010/02/microsoft-random-browser-ballot.html)), you’ll see that using the custom sort function is flawed (although I can’t give you a definitive answer as to why that is!).

If you need to shuffle an array and have a truly random distribution of items, you need to implement the [Fisher-Yates algorithm](https://en.wikipedia.org/wiki/Fisher%E2%80%93Yates_shuffle).

## The Fisher-Yates algorith
Luckily for us, it's not too complicated:

```javascript
const shuffleArray = array => {
  for (let i = array.length - 1; i > 0; i--) {
    const j = Math.floor(Math.random() * (i + 1));
    const temp = array[i];
    array[i] = array[j];
    array[j] = temp;
  }
}
```

As you can see it’s just a case of looping through the array (from the end to the start) and picking a random item from the array and swapping it with the item in the current iteration.

You can use the above function to shuffle an array in JavaScript and get a random result each time.
HacktoberFest-2020
Tags: hacktoberfest
Published: 2020-10-16 09:10:37

## What I Learned From Hacktoberfest
I learned from Hacktoberfest to contribute to open source for the first time and I learned many things along with it like Fork which will create a duplicate repo of another developer in my account in which I can make changes and ask for the pull request to merge the changes I applied.

<!-- What did you learn that can help others contribute to the project you worked on? What did you learn that can help the users of that project?! -->
I have knowledge about web development so I searched for web projects and made changes in them like some projects requires an integration of different pages in one, or some require responsiveness in the different device screen.
selection Sort
Tags: hacktoberfest
Published: 2020-10-16 09:10:17

function selectionSort(arr){

    for(var i = 0; i < arr.length; i++){
    
        var lowest = i;
        
        for(var j = i+1; j < arr.length; j++){
        
            if(arr[j] < arr[lowest]){
            
                lowest = j;
                
            }
            
        }
        
        if(i !== lowest){
        
            console.log(i, lowest)
            
            var temp = arr[i];
            
            arr[i] = arr[lowest];
            
            arr[lowest] = temp;
            
        }
        
    }
    
    return arr;
    
}



function  selectionSort(arr){

    const swap = (arr, idx1, idx2) => 
    
      ([arr[idx1] , arr[idx2]] = [arr[idx2], arr[idx1]]);
      


   for (let i = 0; i < arr.length; i++){
   
     let lowest = i;
     
     for (let j = i + 1; j < arr.length; j++){
     
       if (arr[lowest] > arr[j]) {
       
          lowest = j;               
          
       }
       
     }
     
     if( i !== lowest) swap(arr, i, lowest);
     
   }
   
    return arr;
    
}

selectionSort([0,2,34,22,10,19,17]);
What is JSON Web Token?
Tags: jwt, javascript, webdev, websecurity
Published: 2020-10-16 09:08:25

---
title: What is JSON Web Token?
published: true
description: Introduction to JSON Web Token
tags: jwt, javascript, webdevelopment, websecurity
---
JSON Web Token or JWT is an authorization technique. It is for creating secure web applications.

JWT generally creates a secure way to transfer information between two parties as a JSON object, here the two parties can be a server and a client.

The token contains the user information along with some more additional information. The key difference between Session based authentication and Token based authentication(JWT) is in Token based authentication the user information is not store in the server, the user information stored in the token. Then the token stored in the browser, this is why JWT is considered more scalable than session. 

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/swrqjmspimlutash49bl.png)

In this picture, client makes a post request with `{ email: email, password: password }` to login. The server takes the request then check the email & password then returns a token called JSON Web Token only if email & password both are correct. Then client will store the JWT(token) inside Local Storage or Session Storage.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/1r172ht8eht7dkxm2tcd.png)

Next time client sends a request with JWT(token) attached to get the response. The server verify the token if the token is correct then the server send the response back to the client.

To identify an authenticated person, you just need to put JSON Web Token in the API end point.

```
https://www.something.com/users/?token=eyJhbGciOiJIUzI1NiIs.eyJzdWIiOiIxMj.SflKxwRJSMeKKF2Q
```

Here, `eyJhbGciOiJIUzI1NiIs` is called header, `eyJzdWIiOiIxMj` is called payload & `SflKxwRJSMeKKF2Q` is called signature/crypto.

## JWT Structure

A Header is generally consists two parts, type of the token and the hashing algorithm used. For example,

```js
{
  "algo": "HS256",
  "type": "JWT"
}
```

HS256 signing algorithm being used in the token and type is JWT. Then the header is Base64Url encoded to make first part of the JWT.

The second part of JWT called Payload, the amount of data you want to include into JWT.

```js
{
  "sub": "1234567890",
  "name": "John Doe",
  "iat": 1516239022
}
```

Then the payload is Base64Url encoded to make second part of the JWT.

The last part of JWT is a signature generated based on the Header and Payload. The signature used to verify the JWT is valid or not and the message wasn't changed along the way.

For example, if you want to use HMAC SHA256 algorithm, the signature will be created in the following order,

```js
HMACSHA256(
  base64UrlEncode(header) + "." +
  base64UrlEncode(payload),
  your-256-bit-secret)
```

You can encode and decode if you put all together. Go to https://jwt.io/

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/ue47py7txhoz5ox03zqt.png)
Hacktoberfest 2020
Tags: hacktoberfest
Published: 2020-10-16 09:08:09

## What I Learned From Hacktoberfest
Love the community and open source projects. This was my first time participating in hactoberfest2020. I learnt a lot about the open source community , git and github. What is issue, pull request and how to solve the issue and send it to maintainer. Thank you @hacktoberfest2020 @digitalocean @github for this wonderful opportunity.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/xdhucn1a8ryubf3cp378.jpeg)

I was sucessfully able to complete more than 4 PRs. This has taught me to keep going and I will keep learning and building projects in open source.

<!-- What did you learn that can help others contribute to the project you worked on? What did you learn that can help the users of that project?! -->
Classes Basic
Tags: hacktoberfest
Published: 2020-10-16 09:07:49

class Student {

    constructor(firstName, lastName, year){
    
        this.firstName = firstName;
        
        this.lastName = lastName;
        
        this.grade = year;
        
        this.tradies = 0;
        
        this.scors = [2000, 200]
        
    }
    
    fullName(){ 
    
            console.log(`Your Full Name is ${this.firstName} ${this.lastName}`);
            
            console.log("<------- AND ------->");
            
            console.log(`Your's Age is ${this.grade} Years old`)
            
            console.log("<------- AND ------->");
         
    }
    
    markLate(){
    
        this.tradies += 1;
        
        console.log(`👉👉👉   Your Tradies ${this.tradies} Time Used...`);
        
        if(this.tradies >= 4){
        
            return ` 😲😲 Oh... ${this.firstName} Your Tradies are Expire...!!! 😲😲`
            
            console.log(` Your Tradies ${this.tradies} Time Used...`);
            
        }
        
    }
    
    addScors(scors){
    
        console.log(`${ this.scors}`)
        
    }
    
    calculateAverage(){
    
        let sum = this.scors.reduce(function(a,b){console.log("Answre is ", a+b)})

    }
    
    static enrollStudents(){
    
        console.log("ENROLLING STUDENT...!!!")
        
    }
    
}



let firstStudent = new Student("Your name ", "Your surname ", "Your  year" );

firstStudent.fullName();

firstStudent.markLate();

firstStudent.addScors();

firstStudent.calculateAverage();
vscode-eslint *often* `Extension 'eslint' cannot format xxx`, with no debug output
Tags: help, vscode, webdev, javascript
Published: 2020-10-16 09:04:40

It occurs very often, and I usually have no idea why it occurs, and why it is sometimes automatically solved. (Bugged me for months, maybe more than one year now. I usually used to use Yarn, BTW)

Current project is Nuxt / ESLint / Prettier / TypeScript / PNPM, and I rely on local `.vscode/settings.json`.

```json
{
  "editor.formatOnSave": true,
  "editor.defaultFormatter": "esbenp.prettier-vscode",
  "[typescript]": {
    "editor.defaultFormatter": "dbaeumer.vscode-eslint"
  },
  "[javascript]": {
    "editor.defaultFormatter": "dbaeumer.vscode-eslint"
  }
}
```

Output console.

```
[Info  - 4:05:50 PM] ESLint server is starting
[Info  - 4:05:51 PM] ESLint server running in node v12.14.1
[Info  - 4:05:51 PM] ESLint server is running.
[Info  - 4:05:53 PM] ESLint library loaded from: /home/patarapolw/projects/polv/packages/web/node_modules/.pnpm/eslint@7.11.0/node_modules/eslint/lib/api.js
```
Describe the job interview you'll never forget!
Tags: watercooler, career, interview
Published: 2020-10-16 08:55:44

---
title: Describe the job interview you'll never forget!
published: true
description: 
tags: watercooler, career, interview
cover_image: https://www.iqgenie.org/images/general/job.jpg
---
Most of you have most likely gone through a lot of interviews to build your career path, so have an advantage to compare some interviews over the others.

There are no failed interviews, only the ones we can learn something from. Some of them probably stick out due to being awkward, funny, extremely simple/hard or maybe some that went surprisingly well.

The main focus in this discussion is not on whether you got the offer or not, but why it's still so vivid in your memory?

I though it would be an interesting topic, so could you please tell us how it went?
7 Best Online Courses on R Programming You Should Know
Tags: datascience, machinelearning
Published: 2020-10-16 08:51:53

Hi Guy's,

Whether you are a Beginner in Data Science or experienced data scientist?. In both cases, you know the importance of R programming in the Data Science field.

Having knowledge of R programming is good. But most people are unable to find a good resource for learning R. That's why I have selected Top 7 Online Courses on R Programming here-https://www.mltut.com/best-online-courses-on-r-programming-you-should-know/

All the Best!
Happy Learning!
Screen coordinates to SVG coordinates
Tags: codepen
Published: 2020-10-16 08:50:56

---
title: Screen coordinates to SVG coordinates
published: true
tags: codepen
---

<p>If you want to use mouse coordinates over an SVG element you need to use some code to convert screen coordinates to SVG coordinates. Here is an example of how to do it. Check the CTM transform checkbox to see it in action.
The pulse animation on the unselected checkbox is from another pen: <a href="https://codepen.io/olam/pen/zcqea" target="_blank">https://codepen.io/olam/pen/zcqea</a></p>

<p><em>2020-10-16: Cleaned up code and refactored UI</em></p>

{% codepen https://codepen.io/netsi1964/pen/pWjwgP %}
3.76% Python packages have no summary
Tags: python, hacktoberfest, git
Published: 2020-10-16 08:50:37

---
title: 	3.76% Python packages have no summary
published: true
description: PyDigger collects statistics about Python packages uploaded to PyPI. One of the metrics shown is the percentage of the packages that don't have a summary.
tags: python, hacktoberfest, git
//cover_image: https://direct_url_to_image.jpg
---

The **summary** field of a Python package distributed via [PyPI](https://pypi.org/) is the first thing people searching for packages encounter. Based on the [statistics](https://pydigger.com/stats) collected by [PyDigger](https://pydigger.com/) **3.76%** of the Python packages uploaded to PyPI are missing that field. The full list of those packages can be found [here](https://pydigger.com/search/no-summary).

## Would you like to help adding that field?

Adding this information to the packages can be a nice contribution to both the specific Python package and to the whole Python ecosystem. You will need to understand what the package does and express it in very few words.

Technically in order to make that change easy you'll need to find the repository of the packages. According to the statistics **1.24%** of the packages have a VCS linked from the package. Those will be probably the easiest to fix. Here is the full list of [Python packages with VCS but without a summary](https://pydigger.com/search/has-vcs-no-summary).

There is also some technical details about the [summary field](https://pydigger.com/docs/summary) that can help you.

If you do it now, still in October you might want to first sign up to the [Hacktoberfest](https://hacktoberfest.digitalocean.com/) to have your contribution count there too.


## Improve PyDigger?

Of course PyDigger is also be buggy and it needs a lot more features. The source code can be found in [GitHub](https://github.com/szabgab/pydigger.com/) and it is marked for [Hacktoberfest](https://hacktoberfest.digitalocean.com/).
completed Hacktoberfest 2020
Tags: hacktoberfest
Published: 2020-10-16 08:49:56

## What I Learned From Hacktoberfest

 Hi my name is Rishabh Sharma student of NIT Sikkim , It was a great experience of understanding what open-source and GitHub is, . All I knew about Git and GitHub was how to commit and push changes in a repo. I was way too far from the term Open Source. But during this lockdown due to the global COVID-19 pandemic, I finally decided to understand more of it. Here, I share my experience of working on an open-source project and making my identity in the open-source world.
Open Source is the best way to learn new things, develop skills, collaborate with amazing developers, contribute, and gain experience. 
And on 30 September I heard about hacktoberfest than the day comes all My pull-request are accepted. Thank You Digital ocean
My Github Profile:https://github.com/rishabh-stack
My Linkedin: https://www.linkedin.com/in/rishabh-sharma-40a7951b1/
Digital ocean Hacktoberfest
Tags: hacktoberfest
Published: 2020-10-16 08:47:09

## What I Learned From Hacktoberfest

<!-- What did you learn that can help others contribute to the project you worked on? What did you learn that can help the users of that project?! -->
I learn so many things about different type of laungage as like java,javascript,css,php eventhough i have make my few project which help me for improving my skill . i thik everyone should use it.
A 1 Year Transformation
Tags: hacktoberfest
Published: 2020-10-16 08:42:32

Let's start by previewing 1 year back.
-> New to the computer science world
-> Did not know where to began
->Started Web Development and C 
-> Wrote very poor code and was afraid of any events
Now , 1 year later
->Started making own projects
->Learning ML
->Completed my first HacktoberFest event
->A whole boost of confidence
->Aiming to go higher and higher
Completed Hacktoberfest_Challenge2020
Tags: hacktoberfest
Published: 2020-10-16 08:26:52

## What I Learned From Hacktoberfest

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/1enb0f8pcaujk7dxy6tl.PNG)

Firstly I would like to say that I was a beginner to complete #hacktoberfestChallenge but now I have become little bit better and this is a matter of great importance for me and I learnt a lot during hacktoberfest.

As a learner, I have done the open source project contributions, because of @digitalocean given me a chance to try open source projects hands on and i am very grateful to take this opportunity and get exciting for the next #hacktoberfest_challenge again.

#### Thankyou @digitalocean
HACKTOBERFEST 2020
Tags: hacktoberfest, digitalocean
Published: 2020-10-16 08:23:57

## What I Learned From Hacktoberfest

<!-- What did you learn that can help others contribute to the project you worked on? What did you learn that can help the users of that project?! -->

As I was into open source development from a very long time but this was my first time experience on hacktoberfest. It was a very nice experience. Many people also contributed on my repositories...I merged them adding hacktoberfest-accepted label. Overall, it was a nice experience. @digitalocean @hacktoberfest
How to solve complex problems
Tags: beginners
Published: 2020-10-16 08:22:38

How can you better solve complex coding problems? Here are a few tips:

1. Work test-driven
Write your tests first, and then your code. Like this you can immediately check if your code is doing what you want. Also this helps to have all your code covered with tests.

2. Use the debugger
The debugger is very powerful, as you can run and stop your code line by line and see which values your variables have at the corresponding line, for example.

3. Write detailed pseudo-code
With pseudo-code you write down in “normal language” what your code is supposed to do. Its important that you write very detailed and exact pseudo-code, so that its easy for you to fill in the actual code later.

4. Use coverage tools
There are different coverage tools available, which check which parts are covered by tests and to what degree. Like this its easy for you to fill in the gaps.

What are your tips for solving complex coding problems? Have a nice day! 😊
Enjoyable Moment For me With Hacktoberfest!!
Tags: hacktoberfest
Published: 2020-10-16 08:17:33

## What I Learned From Hacktoberfest -
I will explain it in points
1.I learn what is Open Source.
2.I came to know about how to contribute in any project 
3.I had contributed in Python Repository , Web development respo etc , these all can  help you to understand many things and to contribute in open source.  

<!-- What did you learn that can help others contribute to the project you worked on? What did you learn that can help the users of that project?! -->