excel+courses - vlookup
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Vlookup

excel+courses - Vlookup

resolvedResolved · Low Priority · Version Standard

replyReply Mon 21 Jan 2008, 17:03Delegate Carol said...

Carol has attended:
Excel Intermediate course

Vlookup

Can the lookup value have formulas?

For upcoming training course dates see: Pricing & availability

replyReply Mon 4 Feb 2008, 17:32Trainer Amanda said...

RE: Vlookup

Hi Carol

Thank you for your question, and apologies for the delay in reply.

According to Excel Help, the lookup value needs to be a value, a reference, or a text string, so it would suggest that a lookup value can't be a formula.

I hope this helps.
Amanda

 

Excel tip:

Page Break Preview in Excel 2010

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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard