vlookup

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup

Vlookup

resolvedResolved · Medium Priority · Version 2003

Naomi has attended:
Excel Advanced course

Vlookup

can you do vlookup to search for data on multiple spreadsheets at the same time.

RE: vlookup

Hi Naomi

See this for several worksheets
http://en.allexperts.com/q/Excel-1059/Lookups-across-multiple-sheets.htm

Does this help?

Mon 15 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Page Break Preview in Excel 2010 (Hint/tip)

If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want.

View all Excel hints and tips


Server loaded in 0.09 secs.