Excel Lookups in Multiple Sheets

  • Thread starter Thread starter mklujeske
  • Start date Start date
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
 
something like

=if(iserror(vlookup(var, sheet1range,#,false)),0,vlookup(var
sheet1range,#,false))+if(iserror(vlookup(var
sheet2range,#,false)),0,vlookup(var, sheet2range,#,false)
 
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?
 
You must log in or register to reply here.

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

Excel shortcut options 0
Lookup with two variables 3
how to lookup in numerous different sheets 6
About Lookup and Vlookup 3
EXCEL - FORMULA TO CREATE A TAB REFERENCE 1
lookup and populate with adjacent contents 2
making a portion of reference to a worksheet variable in a formula 1
Complex lookup issue 2

Back
Top