Hi
I'm hoping this will make sense. I've create a sheet that has multiple columns will data validation and vlookup formulas,etc... I'm hoping that some one can show step by step on what I need to capture. okay, let me try to explain. I Have Columns from K1, K3, K4, K6, K8 that have a vlookup formula pulling data from my master table, simple enough. Next I have column A1, C1, D1, F1, G1 that have data validation rules that associate to the vlookup in Columns from K1, K3, K4, K6, K8. So what I am trying to capture is. Whatever is in the data validation section A1, C1, D1, F1, G1 is highlighted based on the vlookup section in Columns K1, K3, K4, K6, K8. The goal is to show what field needs to be selected based on the vlookup section. hope that make sense and thanks for your help.


Tom