Forum Discussion

Lienvds's avatar
Lienvds
Copper Contributor
Dec 14, 2018

How to copy a cell's value IF...

Hi everyone,

 

I've been looking for a solution for this function problem I have and I hope someone can help me out? I'm making a sheet where we keep track of different kinds of money flow during an event. But it's kind of a difficult formula for me. 

 

How it should work (see attachments):

 

  1. If E39 has a value with the word "kluisje" then the value of C39 should be copied into M39 and the value of A37 should be copied into N39.
    => this should work for all cells from E39 until E58, whenever there's a cell with value "kluisje".

  2. BUT... apart from "Catering 2", I also have "Inkom" and "Catering 1" of which I want the values to be copied into N39-N... whenever there's a value with the word "kluisje".

 

To make it more clear: every time we take money from the vault (kluisje) and give it to the entrance (inkom), catering 1 or catering 2, I want it to automatically make a list of all the money that has left the vault so I don't have to fill this out manually at the end of the day.

 

Can anyone help me out? 

Thanks!

 

Lien

 

excel
Formulas and Functions
  • erol sinan zorlu's avatar
    erol sinan zorlu
    Iron Contributor
    Dec 14, 2018

    Are those Catering 1 and Catering 2 in different files? Do you need to copy data from one file to another file? Or are these in the same workheet? If yes have you tried using IF formula?

    For column M:

    =IF($E39="kluisje";$C39;)

    For Column N:

    =IF($E39="kluisje";$A$37;)

    • Lienvds's avatar
      Lienvds
      Copper Contributor
      Dec 14, 2018

      All are in the same worksheet. I have tried the IF formula but I don't know how to make sure that all data that matches with value "kluisje" from all 3 subjects (inkom, cat1 and cat2) can be copied underneath each other in column M...

      • erol sinan zorlu's avatar
        erol sinan zorlu
        Iron Contributor
        Dec 14, 2018

        if they are not in the same table all mixed up you do not need to use a match index formula. so basically a simple if formula will do the trick just be sure to use the correct absolute and mixed reference syntax

Resources