Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Frustration
Show your formulas, otherwise it's impossible to determine what your issue is.
Dave -- Brevity is the soul of wit. "kevincanuk" wrote: Hoping someone can help me with a VLOOKUP problem. I have two simple VLOOKUPS in my workbook. One works great, the other does not. They are virtually the same. They both have the same set of numbers but one is reversed from the other. Example one table looks at 123 and returns 1 124 " " 2 and so on The other is just the opposite looks at 1 " " 123 and so on The problem is the second table works fine but for some reason the first one always returns the last number in the table no matter what number number is entered. Thanks for any help. Kevin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Frustration
Thanks all, here is the formula that I am using.
=IF(A160,(VLOOKUP(A16,trucks,2)),"") I have tried it with out the IF statement ...same problem. "Dave F" wrote: Show your formulas, otherwise it's impossible to determine what your issue is. Dave -- Brevity is the soul of wit. "kevincanuk" wrote: Hoping someone can help me with a VLOOKUP problem. I have two simple VLOOKUPS in my workbook. One works great, the other does not. They are virtually the same. They both have the same set of numbers but one is reversed from the other. Example one table looks at 123 and returns 1 124 " " 2 and so on The other is just the opposite looks at 1 " " 123 and so on The problem is the second table works fine but for some reason the first one always returns the last number in the table no matter what number number is entered. Thanks for any help. Kevin |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Frustration
Try this: =IF(A160,VLOOKUP(A16,trucks,2),"")
Note the parentheses are slightly different than what you have, specifically, you don't need a parentheses before VLOOKUP. Dave -- Brevity is the soul of wit. "kevincanuk" wrote: Thanks all, here is the formula that I am using. =IF(A160,(VLOOKUP(A16,trucks,2)),"") I have tried it with out the IF statement ...same problem. "Dave F" wrote: Show your formulas, otherwise it's impossible to determine what your issue is. Dave -- Brevity is the soul of wit. "kevincanuk" wrote: Hoping someone can help me with a VLOOKUP problem. I have two simple VLOOKUPS in my workbook. One works great, the other does not. They are virtually the same. They both have the same set of numbers but one is reversed from the other. Example one table looks at 123 and returns 1 124 " " 2 and so on The other is just the opposite looks at 1 " " 123 and so on The problem is the second table works fine but for some reason the first one always returns the last number in the table no matter what number number is entered. Thanks for any help. Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Frustration | Excel Worksheet Functions | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |