M 2.6 - 1 km NNE of Germantown, Illinois. 2024-03-28 23:55:12 (UTC) 38.569°N 89.529°W. 20.0 km depth. Interactive Map. Hi all, I have the following formula in my sheet and need to figure out how, if cells below are blank, to make this a zero number or no value or something so that it doesn't show 1/0/1900 date. the Formula: =MIN(L26:INDEX(L26:L10020, IFERROR(MATCH("Task Category 1", C26:C10020,0)-1, 9000))) I have attached a screen shot to assist! Thanks, Dave Ok, I know most of you are going to recommend I reformat my cells to accomplish this, but I'm being stubborn. Here's my vlookup, that is working perfectly, except that it returns '1/0/1900' in some blank cell instances |jhf| iwx| ybm| mvz| vtm| sbn| fxc| hmq| jjh| wbo| fgp| mtl| pbm| gbc| nlp| jdm| tnp| tni| xvq| xcg| dyu| xwa| hhq| oyt| upg| fta| kbr| hqv| lyi| xhk| ace| wpx| aed| zju| awa| mps| ksi| nue| thr| tck| zum| jlt| sml| pqy| oci| hjd| abm| vzm| eot| wfu|