excel+courses - vlookup

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

excel+courses - Vlookup

resolvedResolved · Low Priority · Version Standard

Carol has attended:
Excel Intermediate course

Vlookup

Can the lookup value have formulas?

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:

Removing border lines on the keyboard

Highlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines.

View all Excel hints and tips


Server loaded in 0.09 secs.