VLOOkUP errors

[rz6657]

I'm currently using a combination of IF and VLOOKUP. However, there are cells that will have no data and i get errors (examples below). I prefer the cell to remain blank vs the errors or data it returns...


Using: =IF(D4="","",VLOOKUP(D4,Milestones!F3:U61,7,0))

Examples:

- 1/0/1900
- #N/A

Where there are no dates to return from the Dump tab, I get 1/0/00. I prefer to leave the cell blank
Where the Vlookup does not find the match criteria in the Dump tab, it returns #N/A.i preger to leave the cell blank

I've attached a sample file...

[prashantha]

I cannot find any cell containing fomulae.
in Which cells you need to have this fomula??

[Winon]

Hello rz6657,

Although I would prefer to use Index Match, you could try:

Please Login or Register  to view this content.

[tigeravatar]

Formula:

Please Login or Register  to view this content.

Format cell to Custom format: "m/d/yy;;;@" (no quotes)

[AB33]

If you have excel 2007 and beyond, there is a handy function called "iferror". You can use it with any function if you wish to return other than error

[Moo the Dog]

Would this work:

=IFERROR(VLOOKUP(D4,Milestones!F3:U61,7,0),"")

- Moo

[AB33]

Exactly! You can change this ("") bit in what ever you like.