how can I do a lookup into another sheet?

  • Thread starter Thread starter melawaisi
  • Start date Start date
Try something like

=VLOOKUP(123,Sheet2!A1:B10,2,FALSE)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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

how to lookup in numerous different sheets 6
Lookups - how to obtain data from a master spreadsheet into another 5
Fill Series for Lookup 2
LOOKUP into a different Sheet 1
Lookups? 3
Lookup problems? 1
Lookup with two variables 3
Question regarding lookup 3

Back
Top