Excel Lookups in Multiple Sheets

M

mklujeske

I need to do a lookup for a specific variable within two differen
worksheets. If this possible and how do I go about doing this
 
D

duane

something like

=if(iserror(vlookup(var, sheet1range,#,false)),0,vlookup(var
sheet1range,#,false))+if(iserror(vlookup(var
sheet2range,#,false)),0,vlookup(var, sheet2range,#,false)
 
F

Frank Kabel

Hi
what kind of data do you want to return?. A numeric value or a text
value?. Also coould there be more than one match?
 
Top