inserting values automatically from one sheet to another

  • Thread starter Thread starter jarow
  • Start date Start date
J

jarow

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
 
=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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find a value in a sheet and replace it with another value if it matches 8
Transfer array element offset value to a matched value 3
Find value from one sheet and replace value in second sheet 3
Count the columns from one sheet and paste it in another sheet 0
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Comparing two columns 7
Find the correct sheet then find a value on that sheet 8
Somewhat complex code to copy data from one sheet to another 9

Back
Top