| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP just returns formula
Help, my VLOOKUP is just putting the formula into the cell.
=VLOOKUP(A13,'Tasks'!A2:D10,2,FALSE) Where A13 is on same worksheet as the lookup cell. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP just returns formula
My guess is that you've got the cell formatted as text. Format the cell to
General, then go into edit mode & re-enter the formula. -- David Biddulph "Jan Ogg" wrote in message ... Help, my VLOOKUP is just putting the formula into the cell. =VLOOKUP(A13,'Tasks'!A2:D10,2,FALSE) Where A13 is on same worksheet as the lookup cell. What am I doing wrong? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP just returns formula
Use any cell format other than Text. Then re-enter you formulas or
EditReplace = with = -- Regards Dave Hawley www.ozgrid.com "Jan Ogg" wrote in message ... Help, my VLOOKUP is just putting the formula into the cell. =VLOOKUP(A13,'Tasks'!A2:D10,2,FALSE) Where A13 is on same worksheet as the lookup cell. What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vLookup returns formula and not result | Excel Worksheet Functions | |||
| vlookup returns formula instead of value | Excel Worksheet Functions | |||
| An #N/A returns in Vlookup formula | Excel Worksheet Functions | |||
| Vlookup returns #N/A correctly...but...need formula in another col | Excel Worksheet Functions | |||
| @vlookup returns the formula instead of the value - why? | Excel Worksheet Functions | |||
Linear Mode
