Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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))) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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))) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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))) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Verify if Acct # that is on wksheet is on another | New Users to Excel | |||
how do I set up a spreadsheet and auto update from another wksheet | Excel Worksheet Functions | |||
How do i link an entire source wksheet to a dest' wksheet | Excel Worksheet Functions | |||
Pulling information from another wksheet by date | Excel Discussion (Misc queries) | |||
How to link to a single wksheet in a wkbook that has comments | Excel Discussion (Misc queries) |