vlookup in 2 tables with iferror

[prlondhe]

iam trying to lookup a value in 2 tables with the following formula. the formula works fine but i want a message "not found in any table" if the value not found in both the tables
a b c d
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]891[/TD]
[TD="width: 64, align: right"]10[/TD]
[TD="width: 64, align: right"]894[/TD]
[TD="width: 64, align: right"]60[/TD]
[/TR]
[TR]
[TD="align: right"]892[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]895[/TD]
[TD="align: right"]80[/TD]
[/TR]
[TR]
[TD="align: right"]893[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]896[/TD]
[TD="align: right"]100[/TD]
[/TR]
</tbody>[/TABLE]
the formula is as follows :- IFERROR(VLOOKUP(C9,C3:D5,2,0),VLOOKUP(C9,E3:F5,2,0))

help reqd

 

[VoG]

Try

=IFERROR(VLOOKUP(C9,C3:D5,2,0),IFERROR(VLOOKUP(C9,E3:F5,2,0),"not found"))

 

[Oeldere]

=iferror(IFERROR(VLOOKUP(C9,C3:D5,2,0),VLOOKUP(C9,E3:F5,2,0)),"not found")