Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Bizarre behavior in VLOOKUP function
I have a workbook with two tables, the first containing rooms and the second
containing department codes and department names. I am trying to use VLOOKUP to display the department name next to the alphanumeric department code on each row of the first table (column C): First table (Rooms): RC A B C v 5 Room # Dept Code Dept Desc 6 1023 PH253 = VLOOKUP(B6,'DeptCodes'!$A$2:$C$701,2) .. .. Second Table (DeptCodes, sorted alphabetically) RC A B v 1 Dept Code Dept Desc .. .. 224 PH253 Physics .. .. Here is the bizarre behavior: 1) When I try to copy to formula from C6 to the cells below (C7, C8, etc.), the cell reference does not change. It stays set to C6, even though I have not entered it as an absolute cell reference. I want to use relative cell references precisely so that I can propagate the formula throughout the entire column and have it look up the department for each room. So, that's not working... 2) When I am in cell C6 and I click in the formula editing box, then on the fx symbol to call up the function arguments, everything looks right, and the result evaluates to "Physics", which is correct. But when I press "Ctrl-`" to toggle out of formula auditing mode, the formula results are not displayed, just the column widths increase. 3) When I am in cell C6 and click on "Tools", "Formula auditing", "Evaluate Formula", the result of the evaluation says, "The cell currently being evaluated contains a constant." It's as if the formula (which is correct, isn't it?) is being treated as a text string in one area of the program and as a formula in another area of the program. Apparently, the cell reference ("C6") is being treated as a constant instead of a cell reference. Can anyone explain this flaky behavior? How do I get around this??? Help is greatly appreciated!! -- Michael Boydston-White Project Manager, City College of New York |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can we use multiple if with VLookup function | Excel Worksheet Functions | |||
vlookup Function Help Needed | Excel Worksheet Functions | |||
Pastable function using VLOOKUP? | Excel Worksheet Functions | |||
format cell based on results of vlookup function | Excel Worksheet Functions | |||
Vlookup w/Date Function | Excel Worksheet Functions |