IFERROR twice?

[JoJoF]

Hi

I have a simple formula I’m using to pull data from other tabs on a spreadsheet =IFERROR( VLOOKUP(A33,tab1,9,FALSE),””)

This has been working fine until I now want to pull through data from a field that has a date in it. Now, if the particular cell it’s pulling from doesn’t have a date it shows 00/01/1900 when I would like it to just be a blank cell instead.

It’s like it needs another IFERROR within it but wherever I put it I just get an error

Can someone help me please?

thank you

 

[Fluff]

Hi & welcome to MrExcel.
What is tab1?

 

[JoJoF]

Hi & welcome to MrExcel.
What is tab1?

Hi

thank you ?
The name of the table the data is being pulled from on the other tab

 

[Fluff]

That is not a legal name for a table as it is a cell reference.

 

[Fluff]

However you can use
=IFERROR( 1/(1/VLOOKUP(A33,Tab1,9,FALSE)),"")

 

[JoJoF]

That is not a legal name for a table as it is a cell reference.

i have substituted the actual name of the table as it contains confidential information. The formula works as it is it’s just that I need it to show a blank field If there is no date in the field it is looking up rather than 00/01/1900 as it is doing at the moment.

 

[JoJoF]

However you can use
=IFERROR( 1/(1/VLOOKUP(A33,Tab1,9,FALSE)),"")

Ahh that works perfectly! Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback