Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF ERROR FORMULA
I am getting the result of "0" when there is data in row 20 that needs to be
comming through instead. for instance Sheet 3-16 A2 V20 Piper 8155907568 Sheet 3-9 A2 V20 Piper "blank" New Sheet A2 V20 Piper "0" (when stating the formula as you proposed)=IF(ISNA(VLOOKUP(A2,'3-16'!$L$2:$BF$1538,20,FALSE)),VLOOKUP(A2,'3-9'!$L$2:$BF$1498,20,FALSE),0) Please help. "Luke M" wrote: The False arguement was in the wrong place: =IF(ISNA(VLOOKUP(A2,'3-16'!$L$2:$BF$1538,20,FALSE)),VLOOKUP(A2,'3-9'!$L$2:$BF$1498,20,FALSE),0) -- Best Regards, Luke M "Candida" wrote in message ... i have the following formula written to compare two worksheets that have an identical item number, however column 20 contains vital information and must be collaborated and tracked on a central document. So, I am trying to combine the information by creating a new tracking sheet with the item # in column 1 and hoping to perform a Vlookup to pull in the data from column 20 on both work sheets, ie: if it is not on the '3-16' worksheet then pull information from '3-9' work sheet, or populate as "0". The following formula doesnt seem to be working. Please help =IF(ISNA(VLOOKUP(A2,'3-16'!$L$2:$BF$1538,20,FALSE),0),VLOOKUP(A2,'3-9'!$L$2:$BF$1498,20,FALSE))) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF ERROR FORMULA
On 8 avr, 18:09, "Don Guillett" wrote:
* * * If desired, send your file to my address below. I will only look if: * * * 1. You send a copy of this message on an inserted sheet * * * 2. You give me the newsgroup and the subject line * * * 3. You send a clear explanation of what you want * * * 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Candida" wrote in message ... I am getting the result of "0" when there is data in row 20 that needs to be comming through instead. for instance Sheet 3-16 A2 * * * * * * * * * V20 Piper * * * * * * * 8155907568 Sheet 3-9 A2 * * * * * * * * * *V20 Piper * * * * * * * *"blank" New Sheet A2 * * * * * * * * * V20 Piper * * * * * * * * *"0" (when stating the formula as you proposed)=IF(ISNA(VLOOKUP(A2,'3-16'!$L$2:$BF$1538,20,FALSE)),VLOOKUP(A2,'3-*9'!$L$2:$BF$1498,20,FALSE),0) Please help. "Luke M" wrote: The False arguement was in the wrong place: =IF(ISNA(VLOOKUP(A2,'3-16'!$L$2:$BF$1538,20,FALSE)),VLOOKUP(A2,'3-9'!$L$2:$*BF$1498,20,FALSE),0) -- Best Regards, Luke M "Candida" wrote in message ... i have the following formula written to compare two worksheets that have an identical item number, however column 20 contains vital information and must be collaborated and tracked on a central document. So, I am trying to combine the information by creating a new tracking sheet with the item # in column 1 and hoping to perform a Vlookup to pull in the data from column 20 on both work sheets, ie: if it is not on the '3-16' worksheet then pull information from '3-9' work sheet, or populate as "0". The following formula doesnt seem to be working. Please help =IF(ISNA(VLOOKUP(A2,'3-16'!$L$2:$BF$1538,20,FALSE),0),VLOOKUP(A2,'3-9'!$L$2*:$BF$1498,20,FALSE)))- Masquer le texte des messages précédents - - Afficher le texte des messages précédents - Hello, The stated formula seems to be working like this : if (ISNA(first_vlookup);2nd_vlookup; 0) A test is performed with the first vlookup - the one which looks for the value in A2 in the first column of the specified range ('3-16'!$L $2:$BF$1538) - : - if it does not find a matching value , the vlookup returns #N/A and the IF statement then returns 0 - else the vlookup does not return #N/A and goes to the 2nd vlookup (test another block looking a matching value for A2 ) . Does it match with the data in your file ? Hope this helps |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula error | Excel Discussion (Misc queries) | |||
IF formula returns error; abbreviating the formula | Excel Discussion (Misc queries) | |||
=IF formula #NAME? error | Excel Worksheet Functions | |||
Formula Error | Excel Worksheet Functions | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions |