Bring a cellvalue from sheet2 to sheet1 [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I need to find the department number on sheet2 based on the list on sheet1 and then once that is matched bring the total cost that will be in the same row, but different column.

I don't have experience on programing, but something like this

if value on cell on "columnC sheet1" matches the value on cell on "columnD sheet2" then bring to sheet1 the value of "columnL-columnK sheet2" on that row where value was found.



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!