Previous Topic Next Topic

Bring a cellvalue from sheet2 to sheet1

Closed
kitern - Jun 8, 2010 at 12:25 AM
rizvisa1
Posts
4479
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 reply

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
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