I would greatly appreciate it if someone could give me an idea on how t
do the following:

I have a book with two sheets and want to do the following:

In sheet ONE I have two columns of values: Column A (FAMILY) and Colum
B (GENUS)

In sheet TWO I have two columns, one has values and the other doesn't:
Column A is labled FAMILY but has no values(need to get these value
from the other sheet) and Column B has values (GENUS)

What I need to do is the following:

When a value in Column B (GENUS) in sheet ONE is equal to a value i
Column B (GENUS) in sheet TWO, insert the value of Column A (FAMILY) o
sheet ONE into Column A of Sheet TWO

I hope I have clearly explained this.

Many, many thanks for your hel

--
jaro
-----------------------------------------------------------------------
jarow's Profile: http://www.excelforum.com/member.php...fo&userid=1550
View this thread: http://www.excelforum.com/showthread.php?threadid=27078