Bring a cellvalue from sheet2 to sheet1

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