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