Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP QUESTION
Hi,
If I have 2 sheets both with a list of unique identifiers on it, what is the best way to run a query which will check to see if I have all the IDs in one that are in the other: i.e. Sheet 1: (being the master sheet which will always be correct) A B C D Sheet 2: ( A data sheet reporting on Sheet 1) A B C I woul dlike a formula in sheet 2 to return something like, "ID Missing" or better still: "ID "D" is missing" thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP QUESTION
Kahuna,
Try this ="ID "&IF(COUNTA(Sheet1!A3:A21)=COUNTA(Sheet2!A3:A21)," ",INDIRECT("Sheet1!"&ADDRESS(COUNTA(Sheet1!A2:A20) +1,1)))&" is Missing" Change range to suit Regards Peter "kahuna" wrote: Hi, If I have 2 sheets both with a list of unique identifiers on it, what is the best way to run a query which will check to see if I have all the IDs in one that are in the other: i.e. Sheet 1: (being the master sheet which will always be correct) A B C D Sheet 2: ( A data sheet reporting on Sheet 1) A B C I woul dlike a formula in sheet 2 to return something like, "ID Missing" or better still: "ID "D" is missing" thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Question | Excel Worksheet Functions | |||
Lookup question | Excel Discussion (Misc queries) | |||
LOOKUP question | Excel Worksheet Functions | |||
lookup question | Excel Worksheet Functions | |||
Lookup Question | Excel Worksheet Functions |