Possible to combine VLOOKUP and IF(AND) functions?

I

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?
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP and logical functions 5
VLOOKUP and using a Name in the col_index_num 2
Possible to Combine reports to's to a single box? 0
combine three if functions 3
Custom Worksheet Function - Absolute...? 3
VLOOKUP Tables 2
Vlookup(lookup_value) 1
VLookup formula transposing table_array when copied to another cel 1

Top