Who Form 2220 Dependents 2022-2023

Instructions and Help about Who Form 2220 Dependents

Hey welcome back to the mr. excel NetCast I'm bill jump basically you start out with massive amount of data how we're going to analyze this well let's fire up a pivot table and see if we solve this problem hey welcome back to the mr. Excel NetCast I'm Bill Gellin well vlookup week continues we're talking about vlookups this week this time I have to do a vlookup here in column B I'm going to have to copy the vlookup over to C D and E to grab all four columns so first thing we want to do equal vlookup and when we point back to column a1 press f4 one two three times to lock down just the column a that way as we copy this across it's always going to look back to column a and then over here we'll choose our table so control shift down arrow shift right right right right press f4 one single time to lock that table down and 1 column 2 comma false all right so we copy that across and you see that it is always going to be grabbing column 2 this is the pane full step we've go through and edit these one at a time not bad for four of them but worse if you have monthly data or 36 columns or something like that go through and edit those alright so some things that I've seen I'm going to go on to the next worksheet sometimes we insert an extra little row up here we put the numbers 2 3 4 5 and we use equal vlookup again back to the column a 1 2 3 F 4 choose our range over here control shift down arrow press f4 one single time and then for the...