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
