Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP formula
I am trying to use this function. It works for the first cell and a few odd
ones here and there but isn't working on all of them. Does anyone know how to use this function? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP formula
Lots of us do...
However, given your description, we don't have any idea how you've set up your formula, nor what type of data you're using nor how your data is structured, so it would be pretty difficult to give you any specific help... In article , masonn2 wrote: I am trying to use this function. It works for the first cell and a few odd ones here and there but isn't working on all of them. Does anyone know how to use this function? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP formula
Usually, the most common cause of erratic VLOOKUP results is using a
range_lookup argument of TRUE or 1 (or if omitted it defaults to TRUE). Try setting the range_lookup argument to either 0 or FALSE: =VLOOKUP(A1,C:D,2,0) =VLOOKUP(A1,C:D,2,FALSE) If that doesn't solve your problem then you'll need to show us the *exact* formula you're using and a give us detailed explanation of what you're trying to do. -- Biff Microsoft Excel MVP "masonn2" wrote in message ... I am trying to use this function. It works for the first cell and a few odd ones here and there but isn't working on all of them. Does anyone know how to use this function? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP formula
I have a list of 3 letter codes and the names they represent in a table. I
have a list of about 300 codes some of which are reapeated and I wanted to display the names next to them by having excel refer to the table. Does that make sense? "JE McGimpsey" wrote: Lots of us do... However, given your description, we don't have any idea how you've set up your formula, nor what type of data you're using nor how your data is structured, so it would be pretty difficult to give you any specific help... In article , masonn2 wrote: I am trying to use this function. It works for the first cell and a few odd ones here and there but isn't working on all of them. Does anyone know how to use this function? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP formula
Hi - sounds like you may be copying the formula into a number of other cells.
If this is the case then make sure that the table_array part of the formula (the bit after the 1st comma) is an absolute reference - i.e $A$1:$B$20 , otherwise it will change as you copy the formula and give you errors. TV. "masonn2" wrote: I have a list of 3 letter codes and the names they represent in a table. I have a list of about 300 codes some of which are reapeated and I wanted to display the names next to them by having excel refer to the table. Does that make sense? "JE McGimpsey" wrote: Lots of us do... However, given your description, we don't have any idea how you've set up your formula, nor what type of data you're using nor how your data is structured, so it would be pretty difficult to give you any specific help... In article , masonn2 wrote: I am trying to use this function. It works for the first cell and a few odd ones here and there but isn't working on all of them. Does anyone know how to use this function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup formula | Excel Discussion (Misc queries) | |||
VLOOKUP FORMULA? | Excel Discussion (Misc queries) | |||
Help with IF(VLOOKUP) formula | Excel Discussion (Misc queries) | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
HELP!!! VLOOKUP Formula Help | Excel Discussion (Misc queries) |