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

=Index(Sheet1!$A:$A,Match(Sheet2!B2,Sheet1!$B:$B,0 ),1)

Put this formula in Sheet2, cell A2 and drag fill down the column.
Change sheet names to reflect your sheet names.
--
Regards,
Tom Ogilvy


"jarow" wrote in message
...

I would greatly appreciate it if someone could give me an idea on how to
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 Column
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 values
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 in
Column B (GENUS) in sheet TWO, insert the value of Column A (FAMILY) of
sheet ONE into Column A of Sheet TWO

I hope I have clearly explained this.

Many, many thanks for your help


--
jarow
------------------------------------------------------------------------
jarow's Profile:
http://www.excelforum.com/member.php...o&userid=15507
View this thread: http://www.excelforum.com/showthread...hreadid=270783