Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, then, vlookup
Ok... so I've tried doing this every which way I can think of. I have
multiple spreadsheets that I need to have looked at to verify that the account numbers do not show on any other spreadsheet. Most of the spreadsheets are in seperate workbooks. Here are two of the more detailed functions I've tried: 1. =IF(ISERROR(VLOOKUP(Q2,'[CERTS, DRGS & ADRS.xls]Old CERTs'!$C:$C,1,FALSE)),"",IF(VLOOKUP(Q2,'[CERTS, DRGS & ADRS.xls]Old CERTs'!$C:$C,1,FALSE),"yes",IF(ISERROR(VLOOKUP(Q2, '[CERTS, DRGS & ADRS.xls]A-K'!$O:$O,1,FALSE)),"",IF(VLOOKUP(Q2,'[CERTS, DRGS & ADRS.xls]A-K'!$O:$O,1,FALSE),"yes",IF(ISERROR(VLOOKUP(Q2,'[CERTS, DRGS & ADRS.xls]L-Z'!$O:$O,1,FALSE)),"",IF(VLOOKUP(Q2,'[CERTS, DRGS & ADRS.xls]L-Z'!$O:$O,1,FALSE),"yes","")))))) 2. =IF(VLOOKUP(Q2,'[CERTS, DRGS & ADRS.xls]Old CERTs'!$C:$C,1,FALSE),"yes",IF(ISERROR(VLOOKUP(Q2, '[CERTS, DRGS & ADRS.xls]Old CERTs'!$C:$C,1,FALSE)),"",IF(VLOOKUP(Q2,'[CERTS, DRGS & ADRS.xls]A-K'!$O:$O,1,FALSE),"yes",IF(ISERROR(VLOOKUP(Q2,'[CERTS, DRGS & ADRS.xls]A-K'!$O:$O,1,FALSE)),"",IF(VLOOKUP(Q2,'[CERTS, DRGS & ADRS.xls]L-Z'!$O:$O,1,FALSE),"yes",IF(ISERROR(VLOOKUP(Q2,'[CERTS, DRGS & ADRS.xls]L-Z'!$O:$O,1,FALSE)),"","")))))) Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |