Bring a cellvalue from sheet2 to sheet1

Closed
kitern - Jun 8, 2010 at 12:25 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 8, 2010 at 06:21 AM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 8, 2010 at 06:21 AM
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
0