Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
VLOOKUP - results do not appear in cell
I've attempted to troubleshoot this several different ways. I have used the
Function Arguments to recheck my work and the results show correctly in this dialog box but they do not appear in the cell. Additionally distrubing is that the "Formula results=" line has the correct result too. What does appear is my VLOOKUP formula; =VLOOKUP($C2,Mar05_Master.xls!Property_ID,3,FALSE) . What am I not doing right? |
#2
|
|||
|
|||
Somehow the cell probably got formatted as TEXT...........try deleting the
equal sign and pressing ENTER, then re-inserting the equal sign and pressing ENTER again............... Vaya con Dios, Chuck, CABGx3 "denvertique" wrote in message ... I've attempted to troubleshoot this several different ways. I have used the Function Arguments to recheck my work and the results show correctly in this dialog box but they do not appear in the cell. Additionally distrubing is that the "Formula results=" line has the correct result too. What does appear is my VLOOKUP formula; =VLOOKUP($C2,Mar05_Master.xls!Property_ID,3,FALSE) . What am I not doing right? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions | |||
Confine results of web query to one cell | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions |