Pulling Cell Info from Second Tab, but Need an IFERROR formula

[boojooo]

Hi,

I am pulling information from one tab of a workbook to another (tab1 and tab2). I'm using a basic formula (=Tab!A1), but if A1 is blank I would this formula to return an empty result instead of #N/A.

Any help you can provide is very much appreciated.

Thank you.

 

[ChrisFoster]

You can use conditional formatting for that. What version of Excel are you using?

 

[boojooo]

Office 16, not sure what version of excel that is.

 

[ChrisFoster]

Or you could possibly use;

=IF(Tab1!A1="","",Tab1!A1)

 

[boojooo]

That did the trick, thank you!

 

[ChrisFoster]

That did the trick, thank you!

You're welcome.

 

[boojooo]

Actually, maybe you can help me with a more complicated version with a vlookup involved? Here's the formula:

=IF(VLOOKUP(B5,[BeerDatabase1.xlsx]Sheet1!$A$3:$L$27256,12,FALSE)="","",VLOOKUP(B5,[BeerDatabase1.xlsx]Sheet1!$A$3:$L$27256,12,FALSE))

If B5 is blank, then the value in the cell where this formula exists should turn up empty, but I'm still getting an #N/A

 

[t0azt]

=IFERROR(VLOOKUP(B5,[BeerDatabase1.xlsx]Sheet1!$A$3:$L$27256,12,FALSE),"")