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?


--
Ihoris
------------------------------------------------------------------------
Ihoris's Profile: http://www.excelforum.com/member.php...o&userid=33219
View this thread: http://www.excelforum.com/showthread...hreadid=530405

I think you need something like

=IF(ISNA(lookup_formula_table1),lookup_formula_tab le2,lookup_formula_table1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ihoris" wrote in
message ...

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?


--
Ihoris
------------------------------------------------------------------------
Ihoris's Profile:
http://www.excelforum.com/member.php...o&userid=33219
View this thread: http://www.excelforum.com/showthread...hreadid=530405