Hello,
Im looking for help on how to populate/flashfill a row after the 3rd column. Here is some info of my layout and I will add a picture.
Column "A" Date.... Column "B" Name.... Column "C" though "AA" (would like to auto populate from the rows above with same name.)
Any Help will be greatly appreciated.
Thank you!
Capture-edit.jpg
You can write in VLOOKUP formula with IFERROR in all the cells in columns C through AA.
If the name exists above, it will fill in the data. If not the cells will be blank.
Something like:
=IFERROR(VLOOKUP($B2,$B$2:$AA$100,column()-1,False),"")
Drag it down and across.
1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved
Modytrane
That Seemed to work Great! One Question if you dont mind;
In reference of my Picture, Lets say the second entry of Kevin, i added an X, or removed one. When I type the name and hit enter, it populates off of the first entry instead of the last. Can i make it populate from the last entry, or in other words VLOOKUP bottom to top. If that makes sense lol.
Thank you so much for this, I looked online for about an hour and a half and could not find anything. I will have to learn more into VLOOKUP.
Looks like VLOOKUP won't work in your case. VLOOKUP , Match etc. will work from top down only.
Different approach.
Here's the formula used in attached sample file.
Formula entered in C3 and copied across and down.HTML Code:
When you change values in column C:E for any name, the last value will be copied down.
let me know if you have any questions.
You are awesome!!!! I got it to work, although I had to change some of the cell numbers since the names start on row 5. so I pasted it in C7, I have a screen shot.
I did get a bunch of "0" in the cells. Is that something I did when I changed the formula? I went to File/Options/Advanced/ Scrolled to "Display Options For This Worksheet" section, unchecked the Show A Zero In Cells That Have Zero Value. And that removed the Zeros.
On your sheet its enabled so want to make sure I didnt mess with something.
Thank you so much for this, way more advanced then I am capable of lol.
Attachment 619383
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks