VLOOKUP in Excel 2007
I have 2 columns on an excel spread sheet with the following formula; VLOOKUP(D2,$A$2:$B$2090,2,FALSE) if I copy from column one cell A(2thur209) it produces the corresponding name in column B, but if I type the same name it produces #N/A. What is the problem?

Answer Question   |  August 12, 2009  10:57 PM
Excel 2007, Excel VLOOKUP function, Microsoft Excel 2007, VLOOKUP

Linking Information in two seperate Workbooks
I need to create a Workbook that has certain cells accessible for people to enter in thier information and then have the ability to pick from a drop down list that will autopopulate a name beside the job number chosen. I have managed to do this using V lookup however the main source Workbook opens [...]

Answer Question   |  April 9, 2009  2:22 PM
Excel VLOOKUP function, Microsoft Excel, VLOOKUP

Help with a macro for linking a data entry form spreadsheet to the results spreadsheet
I am entering seminar selection data for 600 students and i have a spreadsheet with names and id numbers. there are 20 seminars that they may attend and they have “ranked” them 1-20. I would i have a data entry sheet with a VLOOKUP that will find the student (on the second sheet) and display [...]

Answer Question   |  February 27, 2009  10:06 PM
Excel macros, Excel VLOOKUP function, Microsoft Excel macros, VLOOKUP function

Multiple VLOOKUP with multiple results
There is 3 sheets 1st master sheet,2nd B-1 & 3rd B-2.In (master sheet) column A there are repeating towers name (eg:B-1,B-2,B-1,B-3), column B there are repeatation of apt. no. (eg: 101,102,101,103,104,102), column C there is a amount(eg: 15000,20000,etc.), i want to give formula in each sheet to get data from the master sheet in ascending [...]

Answer Question   |  October 21, 2008  5:40 AM
Excel formulas, Excel VLOOKUP function, Microsoft Excel, Microsoft Excel formulas, VLOOKUP, VLOOKUP function