Forum Discussion

JLincolnJensen's avatar
JLincolnJensen
Copper Contributor
Jun 06, 2023
Solved

Conditionally filling cells

I have three columns of data. Column one is specific dates pertaining to a number of events recorded on that day in column two.  Ex:              1                 2          Date | Events per day...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jun 06, 2023

    JLincolnJensen 

    =IFERROR(VLOOKUP(C2,$A$2:$B$4,2,FALSE),0)

    VLOOKUP along with IFERROR returns the intended result in my understanding.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jun 06, 2023

JLincolnJensen 

=IFERROR(VLOOKUP(C2,$A$2:$B$4,2,FALSE),0)

VLOOKUP along with IFERROR returns the intended result in my understanding.

 

Resources