microsoft excel training company borough high street london - excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training company borough high street london - Excel

microsoft excel training company borough high street london - Excel

resolvedResolved · Low Priority · Version Standard

Jose has attended:
Excel Advanced course

Excel

Vlookups - How are they run if you are looking from different Workbooks?

Do both workbooks need to kept updated?

Can you Vlookup in multiple workbooks?

RE: excel

You would need to enter the Workbook location, sheet name, and cell range when refering to the Array you want to search in.

ie.
=VLOOKUP(A1,[file.xls]Sheet1!$A$1:$B$21,2,FALSE)

[file.xls]sheetname!cellref:cellref

Yes you would need to update both sheets.

No, you can only lookup on Array at a time.



 

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips


Server loaded in 0.08 secs.