Two Variables
Marc
I have following problem. I have 3 conditions which could appear in Cell A1 ( H1 2011/ H2 2011/ H1 2012 ).
And Cell B1 has one value like the numbers 1015634.
So if H1 2011 appears in A1 excel should search in C1:C10 for the value in B1. The row where it finds the value in C1:C10 for example in row 4 ( C4 ), should be copied then from D4 to F4.
If H2 2011 appears in A1 the search should happen for example in from C11:C20 and also the copy process.
The same when H3 2012 appears in A1.
I hope I was able to explain it correct.
Thanks for your help
Marc