Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare and match test
Hi
I would like to know if the following is possible to complete as a conditional formula. I would like to look at one row of data, look at the first value (child) and then go across and look at the second value (parent). Then test to ensure that against a theoretical table that the relationship is correct. ie has the user entered in the correct parent value for the child value. Data set Child Parent BC001 BI001 Correct - Cell colour left blank A5001 BI001 Incorrect - Cell colour turned red Theoretical table Child Parent BI001 MH002 BC001 BI001 A5001 BC001 Many thanks Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TEST for items in 2 columns to MATCH? | Excel Discussion (Misc queries) | |||
How to match and compare two spreadsheets | Excel Worksheet Functions | |||
compare & match text | Excel Worksheet Functions | |||
Test IF Two Numeric Values Match (from two separate Dynamic Ranges) | Excel Worksheet Functions |