Possible to combine VLOOKUP and IF(AND) functions?

[Ihoris]

Anyone know if it's possible to combine VLOOPUP & IF(AND) functions.
E.g. my VLOOKUP returns a "#N/A" value from my "Table_Array" based on
my "Lookup_Value", can I add the IF(AND) function to the VLOOKUP to
extend the search from the same Table_Array but using another
condition(s)?

E.g. I use VLOOKUP to look up for Product # 12345 (i.e. the
"Lookup_Value") in File 1 from "Table_Array" in File 2 cells $A1:$Z200.
If, for whatever reason, nothing can be found, can I then use the
IF(AND) function to further seach from File 2, perhaps using Product
Name (e.g. Graphic calculator Model B) as the value to lookup for?

 

[Bob Phillips]

I think you need something like

=IF(ISNA(lookup_formula_table1),lookup_formula_table2,lookup_formula_table1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)