VLOOKUP multiple sheets null returns blank cell, otherwise it's alphanumeric

Hello,

I'm attempting to use VLOOKUP to search two different worksheets and return alphanumeric information if it exists. If it does not, I'd like the cell to be blank.

The formula to do this with one sheets works well.

=IF(ISNA(VLOOKUP(C5,General!$A:$I,9,FALSE)),"",VLOOKUP(C5,General!$A:$I,9,FALSE))

I'm not sure how to combine VLOOKUP(C5,Toner!$A:$G,7,FALSE) with it so that it still returns alphanumeric data, or none at all.

Any help would be appreciated.

Thanks,

Walt

Figured it out. Instead of IF(ISNA, I used IFERROR and just nested the other sheet. Here's the forumla:

=IFERROR(VLOOKUP(C3,General!$A:$I,9,FALSE),IFERROR(VLOOKUP(C3,Toner!$A:$G,7,FALSE),""))