ExcelBanter - 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