Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Problems
I am trying to create a VLOOKUP - I want the Table Array to search C:C (all
of column c) - I keep getting an error. Am I doing this incorrectly? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Problems
syntax should be
=VLOOKUP(A1,C:C,1,0) where A1 is the value you are looking for -- Allllen "Erika" wrote: I am trying to create a VLOOKUP - I want the Table Array to search C:C (all of column c) - I keep getting an error. Am I doing this incorrectly? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Problems
=VLOOKUP(99,C:D,2) works from the top of column C to the bottom. Here we
look for 99 in column C and return the adjacent value from column D -- Gary''s Student - gsnu200759 "Erika" wrote: I am trying to create a VLOOKUP - I want the Table Array to search C:C (all of column c) - I keep getting an error. Am I doing this incorrectly? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Problems
I tried both and I get N/A as a result even though I see the match
=VLOOKUP(B2,'Lookup 2'!B:B,1,False) =VLOOKUP(B2,'Lookup 2'!B:B,1,0) "Allllen" wrote: syntax should be =VLOOKUP(A1,C:C,1,0) where A1 is the value you are looking for -- Allllen "Erika" wrote: I am trying to create a VLOOKUP - I want the Table Array to search C:C (all of column c) - I keep getting an error. Am I doing this incorrectly? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Problems
That's the problem, you think you see the match. You might have
leading/trailing spaces or invisible html characters in either the lookup value or in the table or you might use numbers that are text etc. Test one of those that you are sure are matches just simply by using =B2=cell_you_think_is_a_match TRUE or FALSE? then use =LEN(B2) =LEN(cell_you_think_is_a_match) same number, then it's time to check the format =ISNUMBER(B2) and so on -- Regards, Peo Sjoblom "Erika" wrote in message ... I tried both and I get N/A as a result even though I see the match =VLOOKUP(B2,'Lookup 2'!B:B,1,False) =VLOOKUP(B2,'Lookup 2'!B:B,1,0) "Allllen" wrote: syntax should be =VLOOKUP(A1,C:C,1,0) where A1 is the value you are looking for -- Allllen "Erika" wrote: I am trying to create a VLOOKUP - I want the Table Array to search C:C (all of column c) - I keep getting an error. Am I doing this incorrectly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with VLOOKUP | Excel Worksheet Functions | |||
problems with vlookup | Excel Worksheet Functions | |||
VLOOKUP Problems | Excel Discussion (Misc queries) | |||
VLookup Problems | Excel Worksheet Functions | |||
VLookUp Problems | Excel Worksheet Functions |