User Profile
LaVada1050
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Vlook up Formula Needed
Hi Everyone i have a large quantity of data that I need to update daily from excel files. I start with lets say the data on 1-1-2020 and I need to see if there were any changes on 1-2-2020 and input the notes from the 1-1-2020 file to the corresponding matching data on 1-2-2020. "matching" is not enough still leaves me with a ton of corrections that I do not have enough time to do. v or x look up would be the best formula where everyday I can put a new sheet and it will automatically add any matching notes from previous sheets. I want to find & match the information found in c2 on sheet 1 to c2 sheet 2 and input the notes in i2 sheet 1 onto sheet 2 i2, if there are no notes leave blank783Views0likes0Comments- 934Views0likes0Comments
vlook up formula
Vlook up Formula Needed i need a formula where everyday I can put a new sheet and it will automatically add any matching notes from previous sheets. I want to find & match the information found in c2 on sheet 1 to c2 sheet 2 and input the notes in i2 sheet 1 onto sheet 2 i2, if there are no notes leave blank =VLOOKUP(C4,K4:L302,2,FALSE) returned some info but other was NASolved1KViews0likes2Comments
Recent Blog Articles
No content to show