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 a...
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

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

        I tried it with the simple IF formula but this is what I get (picture nr2). It copies the value of the cells but it doesn't paste it underneath each other in the M-column but horizontally at the same row as the other cell.

         

        Also, I'm still not sure how to get all values with the word "kluisje" from rows C6-C20, L6-L20 and C39-C58 copied chronologically underneath each other into the M-column?

Resources