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
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>the formula is as follows :- IFERROR(VLOOKUP(C9,C3:D5,2,0),VLOOKUP(C9,E3:F5,2,0))
help reqd
a b c d
891 | 10 | 894 | 60 |
892 | 20 | 895 | 80 |
893 | 40 | 896 | 100 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
help reqd