Vlookup

[KVR1980]

I've written a nested Vlookup formula that looks across two worksheets (see example below). What I need it to do though is, if the two returning cells are empty then I want the cell to show as blank and not a zero. I know you can use an IF statement to achieve this (see 2nd example below), but I cant seem to combine the IF formula with the IFERROR formula that I need to look across the two worksheets.
Please can someone help me?

=IFERROR(VLOOKUP(A1,Sheet2!A:B,2,0),IFERROR(VLOOKUP(A1,Sheet3!A:B,2,0),""))

=IF(VLOOKUP(A1,Sheet2!A:B,2,0)="","",VLOOKUP(A1,Sheet2!A:B,2,0))

 

[KVR1980]

We need to know whether you are expecting the return value to be a number or text.
If it is Text then you can use the &"" method suggested by @Joe4.
If you are expecting to return a number then that method will convert the numbers that get returned to text.

So if you are expecting numbers unless you have MS365 or O2021 so that you can use the LET function, you will need to do it the long way:

=IFERROR(IF(VLOOKUP(A1,Sheet2!A:B,2,0)="","",VLOOKUP(A1,Sheet2!A:B,2,0)),IFERROR(IF(VLOOKUP(A1,Sheet3!A:B,2,0)="","",VLOOKUP(A1,Sheet3!A:B,2,0)),""))

It's dates Im expecting so used this long formula above, which has worked a treat, thank you so much

 

[Alex Blakenburg]

Glad we could help. Thanks for letting us know.

 

[KVR1980]

We need to know whether you are expecting the return value to be a number or text.
If it is Text then you can use the &"" method suggested by @Joe4.
If you are expecting to return a number then that method will convert the numbers that get returned to text.

So if you are expecting numbers unless you have MS365 or O2021 so that you can use the LET function, you will need to do it the long way:

=IFERROR(IF(VLOOKUP(A1,Sheet2!A:B,2,0)="","",VLOOKUP(A1,Sheet2!A:B,2,0)),IFERROR(IF(VLOOKUP(A1,Sheet3!A:B,2,0)="","",VLOOKUP(A1,Sheet3!A:B,2,0)),""))

It was dates, so this has worked a treat, thanks so much.