Forum

Notifications
Clear all

Help with Excel Formula

3 Posts
3 Users
0 Reactions
57 Views
(@luisndlr)
Posts: 1
New Member
Topic starter
 

Hello,

 

I have 2 sheets in an excel document, my goal is to copy the "Delivery block", "Confirmed Date", and "Created by" columns if the first column of "Sales Document" matches with the second sheet column named "Sales Document". 

 

Is this possible? if you need more info let me know.

 

Thanks!

 
Posted : 27/06/2018 12:34 pm
Anders Sehlstedt
(@sehlsan)
Posts: 970
Prominent Member
 

Hello,

If you can provide a sample file it would be easier to give you a correct answer.

/Anders

 
Posted : 28/06/2018 1:13 am
(@fravis)
Posts: 337
Reputable Member
 

Agree with Anders, but as I read the question we can surely say that this is possible (either with Vlookup or with Index/Match constructions). So with a little sample we can show you how!

Frans

 
Posted : 28/06/2018 5:35 am
Share: