Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP formula appears in the cell I need to see the result in
I am using the VLOOKUP function but when I complete the formula, the formula
just appears in the cell I need the result to show up in. Can anyone help? |
#2
|
|||
|
|||
Hi
it is possible that the cell has been formatted to text prior to the entry of the formula: click on the cell, choose format / cells - number tab and click on general and click ok. then you might need to press F2 then F9 and enter to get it to work or tools / options / view tab, untick formulas or ensure that your VLOOKUP formula has no space before the =VLOOKUP(........ -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Shaynes" wrote in message ... I am using the VLOOKUP function but when I complete the formula, the formula just appears in the cell I need the result to show up in. Can anyone help? |
#3
|
|||
|
|||
Many thanks JulieD - your first option was the case. I had thought of that
initially but only checked the column containing the number range I was searching against and never thought to check the column where I wanted the result to come in to. Many thanks. -- Cheers Sharon "JulieD" wrote: Hi it is possible that the cell has been formatted to text prior to the entry of the formula: click on the cell, choose format / cells - number tab and click on general and click ok. then you might need to press F2 then F9 and enter to get it to work or tools / options / view tab, untick formulas or ensure that your VLOOKUP formula has no space before the =VLOOKUP(........ -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Shaynes" wrote in message ... I am using the VLOOKUP function but when I complete the formula, the formula just appears in the cell I need the result to show up in. Can anyone help? |
#4
|
|||
|
|||
You're welcome, and thanks for the feedback
-- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Shaynes" wrote in message ... Many thanks JulieD - your first option was the case. I had thought of that initially but only checked the column containing the number range I was searching against and never thought to check the column where I wanted the result to come in to. Many thanks. -- Cheers Sharon "JulieD" wrote: Hi it is possible that the cell has been formatted to text prior to the entry of the formula: click on the cell, choose format / cells - number tab and click on general and click ok. then you might need to press F2 then F9 and enter to get it to work or tools / options / view tab, untick formulas or ensure that your VLOOKUP formula has no space before the =VLOOKUP(........ -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Shaynes" wrote in message ... I am using the VLOOKUP function but when I complete the formula, the formula just appears in the cell I need the result to show up in. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP... | Excel Worksheet Functions | |||
if cell starts with characters formula | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
Using Cell references in VLookUp | Excel Worksheet Functions |