98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel VLOOKUP
Excel VLOOKUP
Resolved · Urgent Priority · Version 2003
Tue 24 Jun 2008, 10:34Delegate Ady said...
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.
Tue 24 Jun 2008, 11:39Trainer Amanda said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut keys to move between sheetsInstead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file: |
