IFERROR TO COMPARE WKSHEET
 

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

IFERROR TO COMPARE WKSHEET
 

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

IFERROR TO COMPARE WKSHEET
 

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


.