Vlookup Return Results Issue

[tstagliano]

We have the following VLOOKUP formula to pull date values from multiple sheets and if the source sheet is zero, the results of this formula is coming thru as 1/0/1900. the column is formatted as Date. How can i have the return results comes in as a blank

=IFERROR(VLOOKUP($B2,Candice!$A$2:$AF$500,32,0),IFERROR(VLOOKUP($B2,Dijana!$A$2:$AF$814,32,0),IFERROR(VLOOKUP($B2,Genise!$A$2:$AF$572,32,0),IFERROR(VLOOKUP($B2,Kim!$A$2:$AF$271,32,0),IFERROR(VLOOKUP($B2,Lisa!$A$2:$AF$1173,32,0),IFERROR(VLOOKUP($B2,Mike!$A$2:$AF$11,32,0),IFERROR(VLOOKUP($B2,Shirley!$A$2:$AF$232,32,0),VLOOKUP($B2,Zalak!$A$2:$AF$110,32,0))))))))

[oeldere]

Not an answer to your question, but

Why not make 1 worksheet with all data (e.g. with a macro).

After that you can easily analyse the data (e.g. with a pivot table).

[DBY]

Hello
One easy way would be to Custom Format the cells to hide zero values, for example:

Please Login or Register  to view this content.

The value of the cell(s) would still be 0 but hidden.

DBY

[tstagliano]

We have 8 different people working in separate worksheets and this workbook is a consolidated file that links to each of the individual files so we can do analysis as new information is entered.

[JohnTopley]

One way is to use Conditional formatting to set font to white if cell value = 0

[tstagliano]

thanks DBY. This help cleared up my issue