Here goes. say I have a topic in C6 named banana (drop down menu) and I
want it to look up data( will have from apple to zulu fruit) in G35 :H126 and
if it matchs then put the value of aa2 which is 2 in the appropiate column
in L35:M126. What is the frormula in excel not VBA? IE C6 is apple going down
G column it finds apple at 37, 39, 56, 78,79, 80, 100, 126 and in the H
column it finds apple in 38, 52, 56, 126. I wnt it to put a 2 in each of the
correct cells down the L and M columns.

Thanks in advance