excel 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 » Excel VLOOKUP

Excel VLOOKUP

resolvedResolved · Urgent Priority · Version 2003

Ady has attended:
Excel Advanced course

Excel VLOOKUP

Hello

I have 2 questions please:

1) Is it posible to fix a column index number (eg 8) in a VLOOKUP so that if (at a later date) an additional column is inserted into the lookup array the relevant column index (now 9 ) would be substituted in the VLOOUP formula...as in fixed column reference $H changing to $I

2) I've inherited a spreadsheet which instead of delivering a result in a particular cell (or number of cells) the cell formula is delivered - this is not accross the entire work sheet. What is likely to be causing this and how can i fix it.


RE: Excel VLOOKUP

Hi Ady

Thank you for your questions.

Regarding question 1, vlookup is not designed to work based on entering a column reference, it needs you to input the number of the column within the table array for it to work.

Regarding question 2, try selecting the cell that the cell formula shows in and have a look at the formula bar at the top of the screen. Is there a single quotation mark ' in front of the = sign for the formula? If there is, remove the ' and the formula will operate as you would expect (showing result rather than the formula itself).

I hope this helps.
Amanda


 

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips


Server loaded in 0.13 secs.