I've a rather large amount of data.
In one section (Columns H - U) a daily update of information regarding staff is pasted in.
In another section (AA - AN) is where data from the day prior is held.
Another section (AR - BE) contains all those staffers who have been removed from Columns H - U.
Another section (BJ - BW) is where I have it set up to automatically check the first section against the second and third, and to update any information that has changed.
It is this final updated data that is copied and then moved to a different worksheet for admin usage.
The whole thing works great, with:
Example Formula in BJ8: =IF($BI8="","",IFERROR(VLOOKUP($BI8,$AQ$8:$BE$1219,AB$7,0),IFERROR(VLOOKUP($BI8,$G$8:$U$1219,AB$7,0),VLOOKUP($BI8,$Z$8:$AN$1219,AB$7,0))))
Example Formula in BW8: =IF($BI8="","",IFERROR(VLOOKUP($BI8,$AQ$8:$BE$1219,AO$7,0),IFERROR(VLOOKUP($BI8,$G$8:$U$1219,AO$7,0),VLOOKUP($BI8,$Z$8:$AN$1219,AO$7,0))))
*EXCEPT* The formula I have returns a "01/00/00" (displayed as "01/00/1900") when it finds a blank cell.
This then forces me to "CTRL-H" 5 Columns (BS - BW) to remove all said "01/00/00"s, replacing them with "".
Any ideas on how to make it return a "" (blank, no-characters entered) instead of the "01/00/00"?
Thank you.
Darrell
In one section (Columns H - U) a daily update of information regarding staff is pasted in.
In another section (AA - AN) is where data from the day prior is held.
Another section (AR - BE) contains all those staffers who have been removed from Columns H - U.
Another section (BJ - BW) is where I have it set up to automatically check the first section against the second and third, and to update any information that has changed.
It is this final updated data that is copied and then moved to a different worksheet for admin usage.
The whole thing works great, with:
Example Formula in BJ8: =IF($BI8="","",IFERROR(VLOOKUP($BI8,$AQ$8:$BE$1219,AB$7,0),IFERROR(VLOOKUP($BI8,$G$8:$U$1219,AB$7,0),VLOOKUP($BI8,$Z$8:$AN$1219,AB$7,0))))
Example Formula in BW8: =IF($BI8="","",IFERROR(VLOOKUP($BI8,$AQ$8:$BE$1219,AO$7,0),IFERROR(VLOOKUP($BI8,$G$8:$U$1219,AO$7,0),VLOOKUP($BI8,$Z$8:$AN$1219,AO$7,0))))
*EXCEPT* The formula I have returns a "01/00/00" (displayed as "01/00/1900") when it finds a blank cell.
This then forces me to "CTRL-H" 5 Columns (BS - BW) to remove all said "01/00/00"s, replacing them with "".
Any ideas on how to make it return a "" (blank, no-characters entered) instead of the "01/00/00"?
Thank you.
Darrell
Last edited: