Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup is displaying the formula in its cell not the result??
Vlookup is displaying the formula in its cell not the result??
In excel I can't get the V-lookups I'm running to show their reaults, when creating the vlookup the result is display, but the result doesn't show in the cell with the formula?? Any ideas welcomed?? Thanks Craig |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup is displaying the formula in its cell not the result??
Hi
Formulas don't work in cells formatted as text. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Craig H" <Craig wrote in message ... Vlookup is displaying the formula in its cell not the result?? In excel I can't get the V-lookups I'm running to show their reaults, when creating the vlookup the result is display, but the result doesn't show in the cell with the formula?? Any ideas welcomed?? Thanks Craig |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup is displaying the formula in its cell not the result??
Perhaps the cell is formatted as text. Change it to General, then do an
F2-Enter. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Craig H" <Craig wrote in message ... Vlookup is displaying the formula in its cell not the result?? In excel I can't get the V-lookups I'm running to show their reaults, when creating the vlookup the result is display, but the result doesn't show in the cell with the formula?? Any ideas welcomed?? Thanks Craig |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup is displaying the formula in its cell not the result??
Just to add on a little to Arvi's hint:
Formulas don't work in cells formatted as text. Try re-formatting the cell/col as general (or number), then re-confirm the formula (click inside the formula bar, press ENTER) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency to Text | Excel Worksheet Functions | |||
Formula displays result in formula box but not in cell | Excel Discussion (Misc queries) | |||
Formula displays result in formula box but not in cell | Excel Worksheet Functions | |||
copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
VLOOKUP formula appears in the cell I need to see the result in | Excel Discussion (Misc queries) |