Forum Discussion

Tao Garcia's avatar
Tao Garcia
Copper Contributor
Jun 20, 2017

Search for a value in one row, and then the result is the value from another row

Im Trying to write a formula in excel that would basically say: IF you find in row15 the cell showing !, THEN copy the date value (4/6) assigned at the top of that column in Row2 to a new cell. Im not knowledgeable enough on excel to write the formula in the right language.

 Thanks!

Excel on Mac
Formulas & Functions

2 Replies

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Jun 21, 2017

    Hello,

     

    a formula cannot copy data to another cell. Can you explain to what cell you would like to copy the date?

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 20, 2017

    Hi Tao,

     

    Assuming you have one "!" in row 15, stay on the cell to which you would like to copy the data and enter

     

    =LOOKUP("!",15:15,2:2)

     

Resources