 Hi this is Samantha House and today I'm going to show you how to merge data from two different tabs within the same Google Sheet using VLOOKUP. You can see in this data that I have ELA data and if I open the other tab I have math data and I would like those to both be on the same tab. So I'm going to go to cell E2 the first piece of missing data and I'm going to type in the formula for VLOOKUP. VLOOKUP stands for vertical lookup so equals VLOOKUP and then it's going to give me some hints. So it's going to ask me for my search key. My search key is going to be the student ID. So it's really important that you have student IDs in your data to be able to use this. So I'm going to click on that piece of data and type comma then it's going to ask me for my range. What range of data do I want to look up? So I'm going to go back to my math tab and I'm going to highlight the data range by just clicking and dragging and you can see that the data range appears in the formula. Then I'm going to do a comma and it's going to ask me for my index. My index is going to be the number of the column that I'm pulling data from. So columns are numbered A is column 1, B is column 2, C is column 3, D is column 4, E is column 5, and so on. Because we started pulling our range from column C, column C will be column 1. So I'm going to be pulling from column D which is column 2. So I'm going to type in a 2 and a comma. Now my data is not sorted and I don't want it to pull any data that seems close to the data that I'm looking for. So I'm going to type false and then I can close my parentheses and press enter. So now when I go back to my ELA spreadsheet it is pulled in the math percentile for the first student. What I can do is copy this cell and drag down to the rest of the blank cells and paste and you can see the suggestion shows up and it's added dollar signs between my letters and that locks in the column. So I'm going to click check and now I have merged data from the ELA tab and the math tab. Thanks for watching. Please like and subscribe.